DBA Data[Home] [Help]

APPS.ZX_PTP_MIGRATE_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 182: | 3.AR System Parameters All |

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: | |
185: | SCOPE - PUBLIC |
186: | |

Line 251: | 3.AR System Parameters All |

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: | |
254: | SCOPE - PUBLIC |
255: | |

Line 386: ,Ar_System_Parameters_All ARP

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
388: WHERE XEP.legal_entity_id = HrOuInfo.ORG_INFORMATION2
389: AND XEP.establishment_id = xa.subject_id
390: and atype.association_type_id = xa.association_type_id

Line 526: AR_SYSTEM_PARAMETERS_ALL ArSysParam,

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
529: WHERE
530: nvl(ptp.Party_Type_code,p_party_type_code) = p_party_type_code

Line 822: ,Ar_System_Parameters_All ARP

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
824: WHERE XEP.legal_entity_id = HrOuInfo.ORG_INFORMATION2
825: AND XEP.establishment_id = xa.subject_id
826: and atype.association_type_id = xa.association_type_id

Line 926: ,Ar_System_Parameters_All ARP

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
928: XEP.legal_entity_id = HrOU.organization_id (+) --bug 4519314
929: AND decode(l_multi_org_flag,'N',l_org_id,HrOu.organization_id) =
930: decode(l_multi_org_flag,'N',l_org_id,HrOrgInfo.organization_id(+))