eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PTP_MIGRATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 180: | 1.HR Organization Information |

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: | |

Line 249: | 1.HR Organization Information |

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: | |

Line 364: FROM Hr_Organization_Information HrOrgInfo

360: ---------------Cursor Declarations-----------------------------
361:
362: CURSOR C_GET_REG_NUMBERS IS
363: SELECT (SELECT HrOrgInfo.ORG_INFORMATION2
364: FROM Hr_Organization_Information HrOrgInfo
365: WHERE HrOrgInfo.Org_Information_Context = 'Legal Entity Accounting'
366: AND HrOrgInfo.organization_id = xep.legal_entity_id) ORG_REG_NUM,
367: decode(HrLoc.GLOBAL_ATTRIBUTE_CATEGORY,
368: 'JL.AR.PERWSLOC.LOC',HrLoc.Global_Attribute11||hrloc.Global_Attribute12,

Line 383: ,Hr_Organization_Information HrOuInfo

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
387: ,Zx_party_tax_profile ptp

Line 523: HR_ORGANIZATION_INFORMATION HrOrgInfo,

519: HrLoc.Global_Attribute11||HrLoc.Global_Attribute12 HR_REP_TYPE_INFO_LAT,
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,

Line 776: ,nvl((SELECT HrOrgInfo.ORG_INFORMATION2 FROM Hr_Organization_Information HrOrgInfo

772: SELECT
773: ZX_PARTY_TAX_PROFILE_S.NEXTVAL
774: ,XEP.Party_Id --Party_Id
775: --Bug 4361933
776: ,nvl((SELECT HrOrgInfo.ORG_INFORMATION2 FROM Hr_Organization_Information HrOrgInfo
777: WHERE HrOrgInfo.Org_Information_Context = 'Legal Entity Accounting'
778: AND HrOrgInfo.organization_id = xep.legal_entity_id)
779: ,nvl(decode(hrloc.GLOBAL_ATTRIBUTE_CATEGORY,
780: 'JL.AR.PERWSLOC.LOC',hrloc.Global_Attribute11||hrloc.Global_Attribute12,

Line 819: ,Hr_Organization_Information HrOuInfo

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
823: ,Zx_party_tax_profile ptp

Line 923: ,Hr_Organization_Information HrOrgInfo

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
927: WHERE

Line 1018: Hr_Organization_Information hroi

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 (+)
1022: and decode(l_multi_org_flag,'N',l_org_id,HrOU.organization_id) =