APPS.PAY_NL_WAGE_REPORT_PKG dependencies on DUAL

Line 98: 'from dual where to_char(:payroll_action_id) = dummy';

94: -- Return cursor that selects no rows
95: sqlstr := 'select 1 '||
96: '/* ERROR - Employer Details Fetch failed with: '||
97: sqlerrm(sqlcode)||' */ '||
98: 'from dual where to_char(:payroll_action_id) = dummy';
99: hr_utility.set_location(' Leaving: range code',110);
100: END archive_range_code;
101: --------------------------------------------------------------------------------
102: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id

Line 1092: FROM DUAL

1088: l_tu_sit_payroll_corr_ptd VARCHAR2(30);
1089: --
1090: CURSOR csr_chk_corr_ele_exists(c_pay_act_id NUMBER) IS
1091: SELECT 'Y'
1092: FROM DUAL
1093: WHERE EXISTS (SELECT /*+ ORDERED */ 1
1094: FROM pay_assignment_actions paa
1095: ,pay_action_information pai
1096: WHERE paa.payroll_action_id = c_pay_act_id

Line 2286: FROM DUAL

2282: WHERE ffc.context_name = p_context_name;
2283: --
2284: CURSOR csr_chk_corr_ele_exists(c_ass_act_id NUMBER) IS
2285: SELECT 'Y'
2286: FROM DUAL
2287: WHERE EXISTS (SELECT /*+ ORDERED */ 1
2288: FROM pay_assignment_actions bal_assact
2289: -- ,pay_payroll_actions bact
2290: ,pay_assignment_actions assact

Line 4525: FROM dual;

4521: l_chk_person_id := csr_persons_rec.person_id;
4522: --
4523: SELECT pay_assignment_actions_s.NEXTVAL
4524: INTO l_actid
4525: FROM dual;
4526: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
4527: hr_nonrun_asact.insact(lockingactid => l_actid
4528: ,assignid => csr_persons_rec.assignment_id
4529: ,pactid => p_actid

Line 4544: FROM dual;

4540: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4541: l_chk_assignment_id := csr_rec.assignment_id;
4542: SELECT pay_assignment_actions_s.NEXTVAL
4543: INTO l_actid
4544: FROM dual;
4545: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
4546: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
4547: hr_nonrun_asact.insact(lockingactid => l_actid
4548: ,assignid => csr_rec.assignment_id

Line 4567: FROM dual;

4563: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
4564: l_chk_assignment_id := csr_rec.assignment_id;
4565: SELECT pay_assignment_actions_s.NEXTVAL
4566: INTO l_actid
4567: FROM dual;
4568: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
4569: hr_nonrun_asact.insact(lockingactid => l_actid
4570: ,assignid => csr_rec.assignment_id
4571: ,pactid => p_actid

Line 4619: FROM dual;

4615: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
4616: --
4617: SELECT pay_assignment_actions_s.NEXTVAL
4618: INTO l_actid
4619: FROM dual;
4620: --
4621: hr_nonrun_asact.insact(lockingactid => l_actid
4622: ,assignid => csr_rec.assignment_id
4623: ,pactid => p_actid

Line 5992: FROM DUAL

5988: AND pca.cag_information_category= 'NL';
5989: --
5990: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS
5991: SELECT 'Y'
5992: FROM DUAL
5993: WHERE EXISTS(SELECT /*+ ORDERED */ 1
5994: FROM pay_assignment_actions paa
5995: ,pay_payroll_actions ppa
5996: ,pay_action_interlocks pai

Line 8972: FROM DUAL

8968: AND action_information_category = 'NL_WR_EMPLOYER_INFO';
8969: --
8970: CURSOR csr_chk_exception (c_payroll_action_id NUMBER) IS
8971: SELECT 'EXCEPTION'
8972: FROM DUAL
8973: WHERE EXISTS (SELECT 1
8974: FROM pay_action_information pai
8975: WHERE action_context_id = c_payroll_action_id
8976: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')