APPS.PSP_TEMPLATE_SELECTION dependencies on PAY_PAYROLL_ACTIONS

Line 9: param_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;

5:
6: PROCEDURE insert_into_template_history(p_payroll_action_id IN NUMBER, p_request_id OUT NOCOPY NUMBER ) IS
7: PRAGMA AUTONOMOUS_TRANSACTION;
8:
9: param_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;
10:
11: l_psp_template_id number;
12: l_psp_effort_start date;
13: l_psp_effort_end date;

Line 30: SELECT request_id, legislative_parameters into p_request_id, param_string from pay_payroll_actions where payroll_action_id = p_payroll_action_id;

26:
27: BEGIN
28:
29:
30: SELECT request_id, legislative_parameters into p_request_id, param_string from pay_payroll_actions where payroll_action_id = p_payroll_action_id;
31:
32: l_psp_template_id := get_parameter_value('TEMPLATE_ID', param_string);
33:
34:

Line 228: pay_payroll_actions pact

224:
225: -- fnd_file.put_line(fnd_file.log,'==== cnt sleection '||l_cnt);
226:
227: sqlstr := 'select distinct person_id from psp_selected_persons_t pspt,
228: pay_payroll_actions pact
229: where pact.payroll_action_id = :payroll_action_id and
230: pspt.request_id= pact.request_id ORDER BY pspt.person_id';
231:
232:

Line 3577: token_val pay_payroll_actions.legislative_parameters%type;

3573:
3574:
3575: start_ptr NUMBER;
3576: end_ptr NUMBER;
3577: token_val pay_payroll_actions.legislative_parameters%type;
3578: par_value pay_payroll_actions.legislative_parameters%type;
3579:
3580: BEGIN
3581:

Line 3578: par_value pay_payroll_actions.legislative_parameters%type;

3574:
3575: start_ptr NUMBER;
3576: end_ptr NUMBER;
3577: token_val pay_payroll_actions.legislative_parameters%type;
3578: par_value pay_payroll_actions.legislative_parameters%type;
3579:
3580: BEGIN
3581:
3582: token_val := name||'=';