DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 497: FROM hr_all_organization_units_tl

493: AND pbf.effective_end_date));
494:
495: CURSOR c_name(p_org_id number) IS
496: SELECT name
497: FROM hr_all_organization_units_tl
498: WHERE organization_id = p_org_id
499: AND language = userenv('LANG');
500:
501: CURSOR c_person_id(c_assign_id number) IS

Line 548: lv_gre_name hr_all_organization_units_tl.name%type;

544:
545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;

Line 549: lv_pre_name hr_all_organization_units_tl.name%type;

545: lv_assn_id per_all_assignments_f.assignment_id%type;
546: lv_result_value number;
547: lv_person_id per_all_people_f.person_id%type;
548: lv_gre_name hr_all_organization_units_tl.name%type;
549: lv_pre_name hr_all_organization_units_tl.name%type;
550: lv_emp_name per_all_people_f.full_name%type;
551: lv_emp_no per_all_people_f.employee_number%type;
552: lv_emp_sin per_all_people_f.national_identifier%type;
553: lv_data_row varchar2(4000);