DBA Data[Home] [Help]

APPS.PAY_KW_GENERAL dependencies on PAY_PAYROLL_ACTIONS

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

213: p_parameter_string IN VARCHAR2
214: ,p_token IN VARCHAR2
215: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
216: IS
217: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
218: l_start_pos NUMBER;
219: l_delimiter varchar2(1):=' ';
220: l_proc VARCHAR2(60):= g_package||' get parameter ';
221: BEGIN

Line 276: ,pay_payroll_actions ppa

272: FROM per_assignments_f paf
273: ,per_people_f pef
274: ,pay_pre_payments ppp
275: ,pay_assignment_actions paa
276: ,pay_payroll_actions ppa
277: WHERE paa.payroll_action_id =
278: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
279: AND paa.pre_payment_id = ppp.pre_payment_id
280: AND paa.payroll_action_id = ppa.payroll_action_id

Line 303: ,pay_payroll_actions ppa

299: FROM per_assignments_f paf
300: ,per_people_f pef
301: ,pay_pre_payments ppp
302: ,pay_assignment_actions paa
303: ,pay_payroll_actions ppa
304: WHERE paa.payroll_action_id =
305: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.pre_payment_id = ppp.pre_payment_id
307: AND paa.payroll_action_id = ppa.payroll_action_id