DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 1363: FROM hr_organization_information hoi,

1359: hoi.org_information2 "Employer RFC",
1360: ppf.full_name "Legal Representative Name",
1361: ppf.per_information2 "Legal Representative RFC",
1362: ppf.national_identifier "Legal Representative CURP"
1363: FROM hr_organization_information hoi,
1364: per_people_f ppf
1365: WHERE hoi.organization_id = cp_legal_er_id
1366: AND hoi.org_information_context = 'MX_TAX_REGISTRATION'
1367: AND hoi.org_information3 = ppf.person_id

Line 1571: hr_organization_information hoi,

1567: per_assignments_f paf_all,
1568: pay_assignment_actions paa,
1569: per_periods_of_service pps,
1570: hr_organization_units hou,
1571: hr_organization_information hoi,
1572: hr_locations_all hl,
1573: pay_payroll_actions ppa
1574: WHERE paa.assignment_action_id in
1575: (select assignment_action_id