DBA Data[Home] [Help]

APPS.PER_NL_LTSR_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

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