PJC_XLA_NL_RES_ORG_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
NLR_RES_ORGANIZATION_ID NLR_ORG_COMPANY NLR_ORG_COST_CENTER

Query

SQL_Statement
SELECT hroi.organization_id NLR_RES_Organization_ID, pjc_accounting_pvt.get_company_info(hroi.organization_id) nlr_org_company , pjc_accounting_pvt.get_costcenter_info(hroi.organization_id) nlr_org_cost_center FROM hr_all_organization_units_f hroi WHERE trunc(sysdate) between hroi.effective_start_date and hroi.effective_end_date