DBA Data[Home] [Help]

APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_LOCATIONS_ALL

Line 376: FROM Hr_Locations_All HrLoc

372: PTP.Party_Tax_Profile_Id PTP_ID,
373: HrLoc.Global_Attribute11||HrLoc.Global_Attribute12 HR_REP_TYPE_INFO_LAT,
374: HrLoc.Global_Attribute1 HR_REP_TYPE_INFO_KOR,
375: HrLoc.Global_Attribute2 HR_REP_TYPE_INFO_EUR_GRC
376: FROM Hr_Locations_All HrLoc
377: ,xle_etb_profiles XEP
378: ,xle_associations xa
379: ,xle_association_types atype
380: ,xle_assoc_object_types ctype_obj

Line 524: HR_LOCATIONS_ALL HrLoc,

520: HrLoc.Global_Attribute1 HR_REP_TYPE_INFO_KOR,
521: HrLoc.Global_Attribute2 HR_REP_TYPE_INFO_EUR_GRC
522: FROM
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

Line 688: Hr_Locations_All HrLoc

684: ,Fnd_Global.Conc_Login_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 (+)

Line 812: FROM Hr_Locations_All HrLoc

808: ,Fnd_Global.User_Id -- Who Column
809: ,Sysdate -- Who Column
810: ,Fnd_Global.Conc_Login_Id -- Who Column
811: ,1
812: FROM Hr_Locations_All HrLoc
813: ,xle_etb_profiles XEP
814: ,xle_associations xa
815: ,xle_association_types atype
816: ,xle_assoc_object_types ctype_obj

Line 920: Hr_Locations_All HrLoc

916: ,Sysdate -- Who Column
917: ,Fnd_Global.Conc_Login_Id -- Who Column
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

Line 1016: Hr_Locations_All HrLoc,

1012: ,FND_GLOBAL.CONC_LOGIN_ID
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'