APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 409: from hr_organization_units

405: -- Cursor to get the GRE Name
406: cursor c_gre_name(cp_tax_unit_id number)
407: is
408: select name,business_group_id
409: from hr_organization_units
410: where organization_id = cp_tax_unit_id;
411:
412: -- Cursor to get person_id of the assignments selected
413: cursor c_person_id (cp_assign_id number)

Line 428: lv_gre_name hr_organization_units.name%type;

424: where person_id = cp_person_id;
425:
426: lv_result_value number:=0;
427: lv_person_id per_all_people_f.person_id%type;
428: lv_gre_name hr_organization_units.name%type;
429: lv_gre_type varchar2(10);
430: lv_emp_name per_people_f.full_name%type;
431: lv_emp_no per_people_f.employee_number%type;
432: lv_emp_ssn per_people_f.national_identifier%type;

Line 437: lv_business_group_id hr_organization_units.business_group_id%type;

433: lv_data_row varchar2(4000);
434: l_assignment_inserted number :=0;
435: l_effective_date date;
436: l_temp number;
437: lv_business_group_id hr_organization_units.business_group_id%type;
438:
439: l_elgbl_table_header varchar2(200):= '2. Following employees are eligible for the Year End '||
440: 'Pre-Process archive and marked for Retry:';
441: l_prced_table_header varchar2(200):= '1. Following employees are already processed by the '||

Line 1149: from hr_organization_units

1145: -- Cursor to get gre name
1146: cursor c_get_gre_name(cp_gre_id number)
1147: is
1148: select name
1149: from hr_organization_units
1150: where organization_id = cp_gre_id;
1151:
1152: l_oth_assignment_id per_assignments_f.assignment_id%type;
1153: l_gre_id pay_us_asg_reporting.tax_unit_id%type;