APPS.PAY_SA_GENERAL dependencies on PAY_PAYROLL_ACTIONS

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

139: p_parameter_string IN VARCHAR2
140: ,p_token IN VARCHAR2
141: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
142: IS
143: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
144: l_start_pos NUMBER;
145: l_delimiter varchar2(1):=' ';
146: l_proc VARCHAR2(60):= g_package||' get parameter ';
147: BEGIN

Line 203: ,pay_payroll_actions ppa

199: FROM per_assignments_f paf
200: ,per_people_f pef
201: ,pay_pre_payments ppp
202: ,pay_assignment_actions paa
203: ,pay_payroll_actions ppa
204: WHERE paa.payroll_action_id =
205: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
206: AND paa.pre_payment_id = ppp.pre_payment_id
207: AND paa.payroll_action_id = ppa.payroll_action_id

Line 231: ,pay_payroll_actions ppa

227: FROM per_assignments_f paf
228: ,per_people_f pef
229: ,pay_pre_payments ppp
230: ,pay_assignment_actions paa
231: ,pay_payroll_actions ppa
232: WHERE paa.payroll_action_id =
233: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
234: AND paa.pre_payment_id = ppp.pre_payment_id
235: AND paa.payroll_action_id = ppa.payroll_action_id

Line 275: ,pay_payroll_actions ppa

271: CURSOR csr_get_assact_id IS
272: SELECT paa.assignment_action_id
273: ,ppa.date_earned
274: FROM pay_assignment_actions paa
275: ,pay_payroll_actions ppa
276: ,pay_run_results prr
277: ,pay_element_types_f pet
278: WHERE paa.assignment_id = p_assignment_id
279: AND paa.assignment_action_id = prr.assignment_action_id