eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_DADS_EMP_PKG dependencies on HR_LOCATIONS_ALL

Line 905: ,hr_locations_all hla

901: From per_all_assignments_f asg
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

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 948: ,hr_locations_all hla

944: ,asg_estab_tl.name asg_estab_name
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

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 1060: From hr_locations_all hla

1056: ,hla.postal_code zip_code
1057: ,upper(hla.town_or_city) town
1058: ,hla.country country_code
1059: ,ft_tl.territory_short_name country_name
1060: From hr_locations_all hla
1061: ,fnd_territories ft
1062: ,fnd_territories_tl ft_tl
1063: Where location_id = p_asg_location
1064: And ft.territory_code = hla.country

Line 1263: l_est_location hr_locations_all.location_id%type;

1259:
1260: l_percentage_part_time NUMBER;
1261: l_emp_month_hours NUMBER;
1262: l_estab_monthly_hours NUMBER;
1263: l_est_location hr_locations_all.location_id%type;
1264: l_asg_location hr_locations_all.location_id%type;
1265: l_bal_start_date DATE;
1266: l_value fnd_new_messages.message_text%type;
1267: l_unused_number NUMBER;

Line 1264: l_asg_location hr_locations_all.location_id%type;

1260: l_percentage_part_time NUMBER;
1261: l_emp_month_hours NUMBER;
1262: l_estab_monthly_hours NUMBER;
1263: l_est_location hr_locations_all.location_id%type;
1264: l_asg_location hr_locations_all.location_id%type;
1265: l_bal_start_date DATE;
1266: l_value fnd_new_messages.message_text%type;
1267: l_unused_number NUMBER;
1268: l_first_row BOOLEAN;

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;