APPS.PSP_LABOR_DIST dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 8690: from pay_temp_object_actions

8686: retcode varchar2(1);
8687:
8688: cursor get_chunk_status is
8689: select action_status
8690: from pay_temp_object_actions
8691: where payroll_action_id = p_payroll_action_id
8692: and chunk_number = p_chunk_number;
8693:
8694: l_chunk_status varchar2(10);

Line 8716: from pay_temp_object_actions

8712:
8713:
8714: select min(object_id), max(object_id)
8715: into l_start_asg, l_end_asg
8716: from pay_temp_object_actions
8717: where payroll_action_id = p_payroll_action_id
8718: and chunk_number = p_chunk_number;
8719:
8720: --#fnd_file.put_line(fnd_file.log,'ENTERED ARCHIVE start, end asg='||l_start_asg||','||l_end_asg);

Line 8867: from pay_temp_object_actions

8863: if l_count_fail_actions = 0 then
8864:
8865: select count(*)
8866: into l_count_fail_actions
8867: from pay_temp_object_actions
8868: where payroll_action_id = pactid
8869: and action_status <> 'C';
8870:
8871: end if;