APPS.PAY_NO_TC_REQ dependencies on PAY_PAYROLL_ACTIONS

Line 13: FROM pay_payroll_actions

9: p_token_name VARCHAR2) RETURN VARCHAR2 AS
10:
11: CURSOR csr_parameter_info(p_pact_id IN NUMBER) IS
12: SELECT legislative_parameters
13: FROM pay_payroll_actions
14: WHERE payroll_action_id = p_pact_id;
15:
16: l_token_value VARCHAR2(50);
17: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

Line 17: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

13: FROM pay_payroll_actions
14: WHERE payroll_action_id = p_pact_id;
15:
16: l_token_value VARCHAR2(50);
17: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
18: l_delimiter varchar2(1);
19: l_start_pos NUMBER;
20: --
21:

Line 73: pay_payroll_actions ppa

69:
70: hr_utility.set_location(l_proc_name, 10);
71: p_sqlstr := 'SELECT DISTINCT person_id
72: FROM per_all_people_f ppf,
73: pay_payroll_actions ppa
74: WHERE ppa.payroll_action_id = :payroll_action_id
75: AND ppa.business_group_id = ppf.business_group_id
76: ORDER BY ppf.person_id';
77: hr_utility.set_location(l_proc_name, 20);