APPS.PAY_PROGRESS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 43: FROM fnd_concurrent_requests fcr,pay_payroll_actions ppa

39: NVL(fcr.actual_completion_date,
40: DECODE(cp_done,'Y',ppa.last_update_date,SYSDATE)
41: ) end_time,
42: SYSDATE current_time
43: FROM fnd_concurrent_requests fcr,pay_payroll_actions ppa
44: WHERE fcr.request_id(+) = ppa.request_id
45: AND ppa.payroll_action_id = cp_id;
46: --
47: -- Get the information we need to pass to the existing function

Line 48: -- in the pay_payroll_actions_pkg package, which works out the

44: WHERE fcr.request_id(+) = ppa.request_id
45: AND ppa.payroll_action_id = cp_id;
46: --
47: -- Get the information we need to pass to the existing function
48: -- in the pay_payroll_actions_pkg package, which works out the
49: -- name of the run.
50: CURSOR csr_action(cp_id IN NUMBER) IS
51: SELECT payroll_action_id,
52: action_type,

Line 60: FROM pay_payroll_actions

56: element_set_id,
57: assignment_set_id,
58: effective_date,
59: comments
60: FROM pay_payroll_actions
61: WHERE payroll_action_id = cp_id;
62: --
63: l_progress progress_info_r;
64: l_action csr_action%ROWTYPE;

Line 139: l_progress.run_description := pay_payroll_actions_pkg.v_name(

135: OPEN csr_action(g_action_id);
136: FETCH csr_action INTO l_action;
137: CLOSE csr_action;
138: --
139: l_progress.run_description := pay_payroll_actions_pkg.v_name(
140: l_action.payroll_action_id,
141: l_action.action_type,
142: l_action.consolidation_set_id,
143: l_action.display_run_number,