APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 376: ,Hr_All_Organization_Units HrOU

372: HrLoc.Global_Attribute2 HR_REP_TYPE_INFO_EUR_GRC
373: FROM
374: Hr_Locations_All HrLoc
375: ,xle_etb_profiles XEP
376: ,Hr_All_Organization_Units HrOU
377: ,Hr_Organization_Information HrOrgInfo
378: ,Financials_System_Params_All Fso
379: ,Ap_System_Parameters_All ASP
380: ,Ar_System_Parameters_All ARP

Line 516: HR_ALL_ORGANIZATION_UNITS HrOrgUnits,

512: HR_ORGANIZATION_INFORMATION HrOrgInfo,
513: HR_LOCATIONS_ALL HrLoc,
514: FINANCIALS_SYSTEM_PARAMS_ALL FinSysParam,
515: AR_SYSTEM_PARAMETERS_ALL ArSysParam,
516: HR_ALL_ORGANIZATION_UNITS HrOrgUnits,
517: ZX_PARTY_TAX_PROFILE PTP
518: WHERE
519: nvl(ptp.Party_Type_code,p_party_type_code) = p_party_type_code
520: and ptp.party_id (+) = HrOrgInfo.organization_id

Line 678: ,Hr_All_Organization_Units HrOU

674: ,1
675: FROM
676: xle_entity_profiles XEP,
677: Hr_Locations_All HrLoc
678: ,Hr_All_Organization_Units HrOU
679: ,Financials_System_Params_All Fso
680: WHERE
681: HrOU.location_id = HrLoc.location_id (+)
682: AND decode(l_multi_org_flag,'N',l_org_id,HrOU.organization_id) = decode(l_multi_org_flag,'N',l_org_id,Fso.org_id(+))

Line 802: ,Hr_All_Organization_Units HrOU

798: ,1
799: FROM
800: Hr_Locations_All HrLoc
801: ,xle_etb_profiles XEP
802: ,Hr_All_Organization_Units HrOU
803: ,Hr_Organization_Information HrOrgInfo
804: ,Financials_System_Params_All Fso
805: ,Ap_System_Parameters_All ASP
806: ,Ar_System_Parameters_All ARP

Line 897: Hr_All_Organization_Units hrou,

893: ,1
894: FROM
895: zx_party_tax_profile PTP,
896: Hr_Locations_All HrLoc,
897: Hr_All_Organization_Units hrou,
898: Hr_Organization_Information hroi
899: WHERE
900: PTP.Party_Type_code = 'LEGAL_ESTABLISHMENT'
901: and hrou.location_id= HrLoc.location_id (+)