176: | |
177: | DESCRIPTION |
178: | |
179: | Used to create the registrations for various entities like |
180: | 1.HR Organization Information |
181: | 2.Hr Locations |
182: | 3.AR System Parameters All |
183: | 4.Financial Systems Parameters All |
184: | |
245: | DESCRIPTION |
246: | |
247: | Used to create the reporting type associations |
248: | for various entities like |
249: | 1.HR Organization Information |
250: | 2.Hr Locations |
251: | 3.AR System Parameters All |
252: | 4.Financial Systems Parameters All |
253: | |
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
381: ,Zx_party_tax_profile ptp
508: HrLoc.Global_Attribute11||HrLoc.Global_Attribute12 HR_REP_TYPE_INFO_LAT,
509: HrLoc.Global_Attribute1 HR_REP_TYPE_INFO_KOR,
510: HrLoc.Global_Attribute2 HR_REP_TYPE_INFO_EUR_GRC
511: FROM
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,
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
807: WHERE
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 (+)
902: and decode(l_multi_org_flag,'N',l_org_id,HrOU.organization_id) =