APPS.PER_NL_LTSR_ARCHIVE dependencies on DUAL

Line 350: FROM dual

346: )
347: UNION
348: (
349: SELECT c_org_id
350: FROM dual
351: )
352: )
353: OR nvl (paa.establishment_id,- 1) = c_org_id
354: )

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

655: EXCEPTION
656: WHEN OTHERS THEN
657: -- Return cursor that selects no rows
658: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
659: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
660: END range_code;
661: /**************************************************************************/
662:
663: PROCEDURE initialization_code(p_action_context_id IN NUMBER) IS

Line 805: FROM dual

801: )
802: UNION
803: (
804: SELECT p_org_id
805: FROM dual
806: )
807: )
808: OR nvl (paa.establishment_id,- 1) = p_org_id
809: )

Line 952: FROM dual

948: )
949: UNION
950: (
951: SELECT p_org_id
952: FROM dual
953: )
954: )
955: OR nvl (paa.establishment_id,- 1) = p_org_id
956: )

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

1054: ,p_chunk IN NUMBER)
1055: IS
1056: l_asg_act_id NUMBER;
1057: BEGIN
1058: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1059: hr_nonrun_asact.insact(
1060: lockingactid => l_asg_act_id
1061: ,assignid => p_assignid
1062: ,pactid => p_pactid

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

1418: IF l_exists = 'Y' THEN
1419: fnd_file.put_line(fnd_file.log,'Long Term Sickness Report already sent. Hence skipped.');
1420: ELSIF l_exists = 'N' THEN
1421:
1422: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1423:
1424: hr_nonrun_asact.insact(
1425: lockingactid => l_child_aa_id
1426: , assignid => l_assignment_id