APPS.PER_NL_WAZO_ARCHIVE dependencies on DUAL

Line 354: FROM dual

350: )
351: UNION
352: (
353: SELECT c_org_id
354: FROM dual
355: )
356: )
357: OR nvl (paa.establishment_id,- 1) = c_org_id
358: )

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

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

Line 807: FROM dual

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

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 1584: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;

1580: IF l_exists = 'Y' THEN
1581: fnd_file.put_line(fnd_file.log,'WAZO Report already sent. Hence skipped.');
1582: ELSIF l_exists = 'N' THEN
1583:
1584: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1585:
1586: hr_nonrun_asact.insact(
1587: lockingactid => l_child_aa_id
1588: , assignid => l_assignment_id