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 202: ,pay_payroll_actions ppa

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

Line 229: ,pay_payroll_actions ppa

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

Line 273: ,pay_payroll_actions ppa

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