APPS.PSP_CREATE_EFF_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 19: (select request_id from pay_payroll_actions where payroll_action_id= p_pactid);

15:
16: CURSOR c_person_actions(p_pactid number, stperson NUMBER, endperson NUMBER) is
17: SELECT person_id from psp_selected_persons_t where
18: person_id between stperson and endperson and request_id in
19: (select request_id from pay_payroll_actions where payroll_action_id= p_pactid);
20:
21: begin
22:
23: --fnd_file.put_line(fnd_file.log,'ST===='||stperson||'--END='||endperson);

Line 59: param_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;

55:
56:
57: PROCEDURE PSPREP_INIT(p_payroll_action_id IN NUMBER) IS
58:
59: param_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;
60:
61:
62: BEGIN
63:

Line 68: SELECT request_id, legislative_parameters into g_psp_request_id, param_string from pay_payroll_actions where payroll_action_id = p_payroll_action_id;

64:
65: /* get the required parameters */
66:
67:
68: SELECT request_id, legislative_parameters into g_psp_request_id, param_string from pay_payroll_actions where payroll_action_id = p_payroll_action_id;
69:
70: g_psp_template_id := psp_template_selection.get_parameter_value('TEMPLATE_ID', param_string);
71:
72: g_psp_effort_start:= trunc(fnd_date.canonical_to_date(psp_template_selection.get_parameter_value('START_DATE', param_string)));

Line 1317: -- select request_id into l_retry_request_id from pay_payroll_actions where payroll_action_id = p_pact_id;

1313: Select max(request_id) into l_old_request_id from psp_report_templates_h prth where request_id < p_request_id and payroll_action_id = p_pact_id;
1314:
1315:
1316:
1317: -- select request_id into l_retry_request_id from pay_payroll_actions where payroll_action_id = p_pact_id;
1318:
1319: if g_psp_request_id =p_request_id then
1320: l_retry_request_id :=NULL;
1321: else