[Home] [Help]
378: ,xle_associations xa
379: ,xle_association_types atype
380: ,xle_assoc_object_types ctype_obj
381: ,xle_assoc_object_types ctype_sub
382: ,Hr_All_Organization_Units HrOU
383: ,Hr_Organization_Information HrOuInfo
384: ,Financials_System_Params_All Fso
385: ,Ap_System_Parameters_All ASP
386: ,Ar_System_Parameters_All ARP
523: HR_ORGANIZATION_INFORMATION HrOrgInfo,
524: HR_LOCATIONS_ALL HrLoc,
525: FINANCIALS_SYSTEM_PARAMS_ALL FinSysParam,
526: AR_SYSTEM_PARAMETERS_ALL ArSysParam,
527: HR_ALL_ORGANIZATION_UNITS HrOrgUnits,
528: ZX_PARTY_TAX_PROFILE PTP
529: WHERE
530: nvl(ptp.Party_Type_code,p_party_type_code) = p_party_type_code
531: and ptp.party_id (+) = HrOrgInfo.organization_id
685: ,1
686: FROM
687: xle_entity_profiles XEP,
688: Hr_Locations_All HrLoc
689: ,Hr_All_Organization_Units HrOU
690: ,Financials_System_Params_All Fso
691: WHERE
692: HrOU.location_id = HrLoc.location_id (+)
693: 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(+))
814: ,xle_associations xa
815: ,xle_association_types atype
816: ,xle_assoc_object_types ctype_obj
817: ,xle_assoc_object_types ctype_sub
818: ,Hr_All_Organization_Units HrOU
819: ,Hr_Organization_Information HrOuInfo
820: ,Financials_System_Params_All Fso
821: ,Ap_System_Parameters_All ASP
822: ,Ar_System_Parameters_All ARP
918: ,1
919: FROM
920: Hr_Locations_All HrLoc
921: ,xle_etb_profiles XEP
922: ,Hr_All_Organization_Units HrOU
923: ,Hr_Organization_Information HrOrgInfo
924: ,Financials_System_Params_All Fso
925: ,Ap_System_Parameters_All ASP
926: ,Ar_System_Parameters_All ARP
1013: ,1
1014: FROM
1015: zx_party_tax_profile PTP,
1016: Hr_Locations_All HrLoc,
1017: Hr_All_Organization_Units hrou,
1018: Hr_Organization_Information hroi
1019: WHERE
1020: PTP.Party_Type_code = 'LEGAL_ESTABLISHMENT'
1021: and hrou.location_id= HrLoc.location_id (+)