APPS.PAY_FR_DADS_EMP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 908: ,hr_all_organization_units_tl hou_issue_estab_tl

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
911: Where paa.assignment_action_id = g_assign_action_id
912: and asg.person_id = p_person_id

Line 950: ,hr_all_organization_units_tl hou_issue_estab_tl

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
954: And paa.assignment_id = asg.assignment_id

Line 1317: l_issue_estab_name hr_all_organization_units_tl.name%type;

1313: l_conventional_classification Varchar2(250);
1314: l_per_id Number;
1315: l_cipdz_value varchar2(250);
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:

Line 1330: l_asg_estab_name hr_all_organization_units_tl.name%type;

1326: -- Local Variable Declaration for Exceptions
1327: l_error_type hr_lookups.meaning%type;
1328: l_error hr_lookups.meaning%type;
1329: l_warning hr_lookups.meaning%type;
1330: l_asg_estab_name hr_all_organization_units_tl.name%type;
1331: l_mandatory varchar2(1);
1332: l_conditional varchar2(1);
1333: l_optional varchar2(1);
1334: