APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on HR_ORGANIZATION_UNITS

Line 367: FROM hr_organization_units

363:
364: CURSOR c_gre_or_pre_name(p_tax_unit_id number)
365: IS
366: SELECT name
367: FROM hr_organization_units
368: WHERE organization_id = p_tax_unit_id;
369:
370: CURSOR c_person_id (c_assign_id number)
371: IS

Line 406: FROM hr_organization_units

402: CURSOR c_get_business_group_id(c_tax_unit_id number
403: )
404: IS
405: SELECT business_group_id
406: FROM hr_organization_units
407: WHERE organization_id = c_tax_unit_id;
408:
409: CURSOR c_get_missing_assignments(cp_payroll_action_id NUMBER,
410: cp_tax_unit_id NUMBER)

Line 469: lv_gre_or_pre_name hr_organization_units.name%type;

465: );
466:
467: lv_result_value number:=0;
468: lv_person_id per_people_f.person_id%type;
469: lv_gre_or_pre_name hr_organization_units.name%type;
470: lv_emp_name per_people_f.full_name%type;
471: lv_emp_no per_people_f.employee_number%type;
472: lv_emp_ssn per_people_f.national_identifier%type;
473: lv_data_row VARCHAR2(4000);