APPS.PAY_US_MMREF_REPORTING dependencies on DUAL

Line 381: FROM dual

377: --any of the assignments for federal W
378:
379: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
380: SELECT '1'
381: FROM dual
382: WHERE EXISTS (SELECT '1'
383: FROM pay_assignment_actions paa
384: WHERE paa.payroll_action_id = cp_payroll_action_id
385: AND paa.action_status = 'E'

Line 396: FROM dual

392: --Cursor for checking if any of the assignments have been marked for retry
393:
394: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
395: SELECT '1'
396: FROM dual
397: WHERE EXISTS (SELECT '1'
398: FROM pay_assignment_actions paa
399: WHERE paa.payroll_action_id = cp_payroll_action_id
400: AND paa.action_status = 'M')

Line 2262: FROM dual;

2258: IF (l_report_type = 'FEDW2' and l_value <> 0 ) OR
2259: (l_report_type = 'STW2') then
2260: SELECT pay_assignment_actions_s.nextval
2261: INTO lockingactid
2262: FROM dual;
2263: hr_utility.set_location(
2264: 'pay_us_mmref_reporting.create_assignement_act', 60);
2265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
2266: p_chunk, l_tax_unit_id);

Line 2680: FROM DUAL

2676:
2677:
2678: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS
2679: SELECT 'RG'
2680: FROM DUAL
2681: WHERE EXISTS
2682: (SELECT NULL
2683: FROM pay_payroll_actions ppa,
2684: ff_archive_items fai

Line 2766: FROM DUAL

2762: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
2763:
2764: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS
2765: SELECT 'RG'
2766: FROM DUAL
2767: WHERE EXISTS
2768: (SELECT NULL
2769: FROM pay_payroll_actions ppa,
2770: ff_archive_items fai