APPS.PAY_CA_YEPP_ADD_ACTIONS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 457: from hr_all_organization_units_tl

453: -- Cursor to get the GRE or PRE Name
454:
455: cursor c_name (cp_org_id number) is
456: select name
457: from hr_all_organization_units_tl
458: where organization_id = cp_org_id
459: and language = userenv('LANG');
460:
461: -- Cursor to get person_id of the assignments selected

Line 481: lv_gre_name hr_all_organization_units_tl.name%type;

477: from per_all_assignments_f
478: where assignment_id = cp_assign_id;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;

Line 482: lv_pre_name hr_all_organization_units_tl.name%type;

478: where assignment_id = cp_assign_id;
479:
480: lv_person_id per_all_people_f.person_id%type;
481: lv_gre_name hr_all_organization_units_tl.name%type;
482: lv_pre_name hr_all_organization_units_tl.name%type;
483: lv_emp_name per_all_people_f.full_name%type;
484: lv_emp_no per_all_people_f.employee_number%type;
485: lv_emp_sin per_all_people_f.national_identifier%type;
486: lv_data_row varchar2(4000);

Line 1595: from hr_all_organization_units_tl

1591: and hou1.organization_id = hoi1.organization_id);
1592:
1593: cursor c_get_name(cp_org_id number) is
1594: select name
1595: from hr_all_organization_units_tl
1596: where organization_id = cp_org_id
1597: and language = userenv('LANG');
1598:
1599: l_oth_assignment_id per_all_assignments_f.assignment_id%type;