APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

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 536: hr_all_organization_units hou

532:
533: CURSOR c_all_gres(cp_pre_id number) IS
534: SELECT hoi.organization_id gre_id
535: FROM hr_organization_information hoi,
536: hr_all_organization_units hou
537: WHERE hoi.org_information_context = 'Canada Employer Identification'
538: AND hoi.org_information2 = to_char(cp_pre_id)
539: AND hou.business_group_id = p_bus_grp
540: AND hou.organization_id = hoi.organization_id;

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);