DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on HR_LOCATIONS_ALL_TL

Line 906: ,hr_locations_all_tl hloc_asg_estab_tl

902: ,pay_assignment_actions paa
903: ,hr_organization_information org_est
904: ,hr_all_organization_units hou
905: ,hr_locations_all hla
906: ,hr_locations_all_tl hloc_asg_estab_tl
907: -- Getting the Establishment Name
908: ,hr_all_organization_units_tl hou_issue_estab_tl
909: -- Getting the Assignment Establishment's Name
910: ,hr_all_organization_units asg_estab_tl

Line 949: ,hr_locations_all_tl hloc_asg_estab_tl

945: From pay_assignment_actions paa
946: ,per_all_assignments_f asg
947: ,hr_organization_information org_est
948: ,hr_locations_all hla
949: ,hr_locations_all_tl hloc_asg_estab_tl
950: ,hr_all_organization_units_tl hou_issue_estab_tl
951: ,hr_all_organization_units asg_estab_tl
952: ,hr_all_organization_units hou
953: Where paa.assignment_action_id = g_assign_action_id

Line 1320: l_location_name hr_locations_all_tl.location_code%type;

1316: --Names
1317: l_issue_estab_name hr_all_organization_units_tl.name%type;
1318: l_emp_full_name per_all_people_f.full_name%type;
1319: l_country_code Varchar2(30);
1320: l_location_name hr_locations_all_tl.location_code%type;
1321:
1322: --Variable to hold the last payroll run date, which has been executed just before the dads period
1323: c_end_date date;
1324: c_start_date date;