DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on HR_ORGANIZATION_INFORMATION

Line 1143: FROM hr_organization_information hoi,

1139: hoi.org_information2 "Employer RFC",
1140: ppf.full_name "Legal Representative Name",
1141: ppf.per_information2 "Legal Representative RFC",
1142: ppf.national_identifier "Legal Representative CURP"
1143: FROM hr_organization_information hoi,
1144: per_people_f ppf
1145: WHERE hoi.organization_id = cp_legal_er_id
1146: AND hoi.org_information_context = 'MX_TAX_REGISTRATION'
1147: AND hoi.org_information3 = ppf.person_id

Line 1333: hr_organization_information hoi,

1329: per_assignments_f paf_all,
1330: pay_assignment_actions paa,
1331: per_periods_of_service pps,
1332: hr_organization_units hou,
1333: hr_organization_information hoi,
1334: hr_locations_all hl,
1335: pay_payroll_actions ppa
1336: WHERE paa.assignment_action_id in
1337: (select assignment_action_id