DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on HR_LOCATIONS_ALL

Line 1551: hr_locations_all hl

1547: hoi6.org_information3 ei_rate
1548: from
1549: hr_all_organization_units hou,
1550: hr_organization_information hoi6,
1551: hr_locations_all hl
1552: where
1553: hou.organization_id = p_tax_unit_id
1554: and hou.organization_id = hoi6.organization_id
1555: and hoi6.org_information_context = 'Canada Employer Identification'

Line 1608: hr_locations_all hl

1604: from
1605: hr_all_organization_units hou,
1606: hr_organization_information hoi2,
1607: hr_organization_information hoi3,
1608: hr_locations_all hl
1609: where
1610: hou.organization_id = p_transmitter_gre_id
1611: and hou.organization_id = hoi2.organization_id
1612: and hoi2.org_information_context = 'Fed Magnetic Reporting'

Line 2415: ,hr_locations_all hl

2411: select distinct(paf.assignment_id)
2412: from per_all_assignments_f paf
2413: ,per_all_people_f ppf
2414: ,hr_soft_coding_keyflex_kfv hsc
2415: ,hr_locations_all hl
2416: where ppf.person_id = p_person_id
2417: and ppf.person_id = paf.person_id
2418: and hsc.segment1 = l_tax_unit_id
2419: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id