APPS.PAY_US_MARK_W2C_PAPER dependencies on HR_ORGANIZATION_UNITS

Line 437: FROM hr_organization_units

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

Line 454: lv_gre_name hr_organization_units.name%type;

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