DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PAY_PAYROLL_ACTIONS

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

227: p_parameter_string IN VARCHAR2
228: ,p_token IN VARCHAR2
229: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
230: IS
231: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
232: l_start_pos NUMBER;
233: l_delimiter varchar2(1):=' ';
234: l_proc VARCHAR2(60):= g_package||' get parameter ';
235: BEGIN

Line 290: ,pay_payroll_actions ppa

286: FROM per_assignments_f paf
287: ,per_people_f pef
288: ,pay_pre_payments ppp
289: ,pay_assignment_actions paa
290: ,pay_payroll_actions ppa
291: WHERE paa.payroll_action_id =
292: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
293: AND paa.pre_payment_id = ppp.pre_payment_id
294: AND paa.payroll_action_id = ppa.payroll_action_id

Line 317: ,pay_payroll_actions ppa

313: FROM per_assignments_f paf
314: ,per_people_f pef
315: ,pay_pre_payments ppp
316: ,pay_assignment_actions paa
317: ,pay_payroll_actions ppa
318: WHERE paa.payroll_action_id =
319: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
320: AND paa.pre_payment_id = ppp.pre_payment_id
321: AND paa.payroll_action_id = ppa.payroll_action_id

Line 345: ,pay_payroll_actions ppa

341: FROM per_assignments_f paf
342: ,per_people_f pef
343: ,pay_pre_payments ppp
344: ,pay_assignment_actions paa
345: ,pay_payroll_actions ppa
346: WHERE paa.payroll_action_id =
347: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
348: AND paa.pre_payment_id = ppp.pre_payment_id
349: AND paa.payroll_action_id = ppa.payroll_action_id

Line 373: ,pay_payroll_actions ppa

369: FROM per_assignments_f paf
370: ,per_people_f pef
371: ,pay_pre_payments ppp
372: ,pay_assignment_actions paa
373: ,pay_payroll_actions ppa
374: WHERE paa.payroll_action_id =
375: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
376: AND paa.pre_payment_id = ppp.pre_payment_id
377: AND paa.payroll_action_id = ppa.payroll_action_id