APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PAY_US_RPT_TOTALS

Line 349: archived in PAY_US_RPT_TOTALS by the

345:
346: /* ******************************************************
347: Name: select_employee
348: Description: This procedure fetches the assignments
349: archived in PAY_US_RPT_TOTALS by the
350: package PAY_ARCHIVE_MISSING_ASG_PKG
351: and generates the report in the specified
352: format.
353: *****************************************************/

Line 413: FROM PAY_US_RPT_TOTALS

409: CURSOR c_get_missing_assignments(cp_payroll_action_id NUMBER,
410: cp_tax_unit_id NUMBER)
411: IS
412: SELECT distinct value1
413: FROM PAY_US_RPT_TOTALS
414: WHERE location_id = cp_payroll_action_id
415: AND tax_unit_id = cp_tax_unit_id
416: AND attribute1 = 'YEAR END MISSING ASSIGNMENTS';
417:

Line 551: /* Report assignments picked up from PAY_US_RPT_TOTALS*/

547:
548: open c_get_legislation_code(lv_business_group_id);
549: fetch c_get_legislation_code into lv_legislation_code;
550: close c_get_legislation_code;
551: /* Report assignments picked up from PAY_US_RPT_TOTALS*/
552:
553: hr_utility.set_location(gv_package_name || '.select_employee', 30);
554:
555: OPEN c_get_missing_assignments(p_payroll_action_id, nvl(p_tax_unit_id,0));