APPS.PAY_US_MARK_W2C_PAPER dependencies on HR_ORGANIZATION_UNITS

Line 435: FROM hr_organization_units

431:
432:
433: cursor gre_name (cp_tax_unit_id in varchar2) is
434: SELECT name
435: FROM hr_organization_units
436: WHERE organization_id = cp_tax_unit_id;
437:
438: cursor get_paper_details (cp_assignment_action_id in number) is
439: select creation_date

Line 452: lv_gre_name hr_organization_units.name%type;

448: lv_full_name per_all_people_f.full_name%type;
449: lv_national_identifier per_all_people_f.national_identifier%type;
450: lv_employee_number per_all_people_f.employee_number%type;
451: lv_assignment_number per_all_assignments_f.assignment_number%type;
452: lv_gre_name hr_organization_units.name%type;
453: lv_year varchar2(4) ;
454: lv_creation_date varchar2(20) ;
455: lv_sysdate varchar2(20) ;
456: