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: )
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:
805: )
806: UNION
807: (
808: SELECT p_org_id
809: FROM dual
810: )
811: )
812: OR nvl (paa.establishment_id, - 1) = p_org_id
813: )
953: )
954: UNION
955: (
956: SELECT p_org_id
957: FROM dual
958: )
959: )
960: OR nvl (paa.establishment_id, - 1) = p_org_id
961: )
1057: ,p_chunk IN NUMBER)
1058: IS
1059: l_asg_act_id NUMBER;
1060: BEGIN
1061: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_act_id FROM dual;
1062: hr_nonrun_asact.insact(
1063: lockingactid => l_asg_act_id
1064: ,assignid => p_assignid
1065: ,pactid => p_pactid
1459: IF l_SR_exists = 'N' THEN
1460: fnd_file.put_line(fnd_file.log,'Sickness Report not sent. Hence skipped.');
1461: ELSIF l_SR_exists = 'Y' THEN
1462:
1463: SELECT pay_assignment_actions_s.NEXTVAL INTO l_child_aa_id FROM dual;
1464: hr_nonrun_asact.insact(
1465: lockingactid => l_child_aa_id
1466: , assignid => l_assignment_id
1467: , pactid => l_payroll_action_id