DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on HR_LOCATIONS

Line 294: from hr_locations hrloc,

290: select nvl(hrloc.loc_information17,hrloc.region_2),
291: nvl(hrloc.loc_information19,hrloc.region_1),
292: nvl(hrloc.loc_information18,hrloc.town_or_city),
293: nvl(hrloc.loc_information20,hrloc.postal_code)
294: from hr_locations hrloc,
295: hr_soft_coding_keyflex hrsckf,
296: per_all_assignments_f assign,
297: pay_assignment_actions paa
298: where paa.assignment_id = assign.assignment_id

Line 2641: hr_locations_all loc

2637: SELECT
2638: org.NAME,loc.telephone_number_1
2639: FROM
2640: hr_all_organization_units org,
2641: hr_locations_all loc
2642: WHERE
2643: org.location_id=loc.location_id
2644: AND org.organization_id = cp_organization_id;
2645: