DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PAY_PAYROLL_ACTIONS

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

265: p_parameter_string IN VARCHAR2
266: ,p_token IN VARCHAR2
267: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
268: IS
269: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
270: l_start_pos NUMBER;
271: l_delimiter varchar2(1):=' ';
272: l_proc VARCHAR2(60):= g_package||' get parameter ';
273: BEGIN

Line 328: ,pay_payroll_actions ppa

324: FROM per_assignments_f paf
325: ,per_people_f pef
326: ,pay_pre_payments ppp
327: ,pay_assignment_actions paa
328: ,pay_payroll_actions ppa
329: WHERE paa.payroll_action_id =
330: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
331: AND paa.pre_payment_id = ppp.pre_payment_id
332: AND paa.payroll_action_id = ppa.payroll_action_id

Line 355: ,pay_payroll_actions ppa

351: FROM per_assignments_f paf
352: ,per_people_f pef
353: ,pay_pre_payments ppp
354: ,pay_assignment_actions paa
355: ,pay_payroll_actions ppa
356: WHERE paa.payroll_action_id =
357: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
358: AND paa.pre_payment_id = ppp.pre_payment_id
359: AND paa.payroll_action_id = ppa.payroll_action_id

Line 383: ,pay_payroll_actions ppa

379: FROM per_assignments_f paf
380: ,per_people_f pef
381: ,pay_pre_payments ppp
382: ,pay_assignment_actions paa
383: ,pay_payroll_actions ppa
384: WHERE paa.payroll_action_id =
385: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
386: AND paa.pre_payment_id = ppp.pre_payment_id
387: AND paa.payroll_action_id = ppa.payroll_action_id

Line 411: ,pay_payroll_actions ppa

407: FROM per_assignments_f paf
408: ,per_people_f pef
409: ,pay_pre_payments ppp
410: ,pay_assignment_actions paa
411: ,pay_payroll_actions ppa
412: WHERE paa.payroll_action_id =
413: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
414: AND paa.pre_payment_id = ppp.pre_payment_id
415: AND paa.payroll_action_id = ppa.payroll_action_id

Line 956: ,pay_payroll_actions ppa

952: CURSOR csr_get_assact_id IS
953: SELECT paa.assignment_action_id
954: ,ppa.date_earned
955: FROM pay_assignment_actions paa
956: ,pay_payroll_actions ppa
957: ,pay_run_results prr
958: ,pay_element_types_f pet
959: WHERE paa.assignment_id = p_assignment_id
960: AND paa.assignment_action_id = prr.assignment_action_id