APPS.PER_NL_DSR_ARCHIVE dependencies on DUAL

Line 484: FROM dual

480: )
481: UNION
482: (
483: SELECT c_org_id
484: FROM dual
485: )
486: )
487: OR nvl (paa.establishment_id,- 1) = c_org_id
488: )

Line 793: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

789: EXCEPTION
790: WHEN OTHERS THEN
791: -- Return cursor that selects no rows
792: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
793: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
794: END range_code;
795:
796: /**************************************************************************/
797:

Line 940: FROM dual

936: )
937: UNION
938: (
939: SELECT p_org_id
940: FROM dual
941: )
942: )
943: OR nvl (paa.establishment_id,- 1) = p_org_id
944: )

Line 1087: FROM dual

1083: )
1084: UNION
1085: (
1086: SELECT p_org_id
1087: FROM dual
1088: )
1089: )
1090: OR nvl (paa.establishment_id,- 1) = p_org_id
1091: )

Line 1194: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;

1190: ,p_chunk IN NUMBER)
1191: IS
1192: l_asg_act_id NUMBER;
1193: BEGIN
1194: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1195: hr_nonrun_asact.insact(
1196: lockingactid => l_asg_act_id
1197: ,assignid => p_assignid
1198: ,pactid => p_pactid

Line 1831: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;

1827: IF l_exists = 'Y' THEN
1828: fnd_file.put_line(fnd_file.log,'Sickness Report already sent. Hence skipped.');
1829: ELSIF l_exists = 'N' THEN
1830:
1831: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1832:
1833: hr_nonrun_asact.insact(
1834: lockingactid => l_child_aa_id
1835: , assignid => l_assignment_id