APPS.PER_NL_LTSRR_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 660: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

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

Line 811: FROM dual

807: )
808: UNION
809: (
810: SELECT p_org_id
811: FROM dual
812: )
813: )
814: OR nvl (paa.establishment_id, - 1) = p_org_id
815: )

Line 960: FROM dual

956: )
957: UNION
958: (
959: SELECT p_org_id
960: FROM dual
961: )
962: )
963: OR nvl (paa.establishment_id, - 1) = p_org_id
964: )

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

1060: ,p_chunk IN NUMBER)
1061: IS
1062: l_asg_act_id NUMBER;
1063: BEGIN
1064: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1065: hr_nonrun_asact.insact(
1066: lockingactid => l_asg_act_id
1067: ,assignid => p_assignid
1068: ,pactid => p_pactid

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

1478: IF l_LTSR_exists = 'N' THEN
1479: fnd_file.put_line(fnd_file.log,'Long Term Sickness Report not sent. Hence skipped.');
1480: ELSIF l_LTSR_exists = 'Y' THEN
1481:
1482: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1483: hr_nonrun_asact.insact(
1484: lockingactid => l_child_aa_id
1485: , assignid => l_assignment_id
1486: , pactid => l_payroll_action_id