APPS.PAY_FI_ARCHIVE_MTRA dependencies on PAY_PAYROLL_ACTIONS

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

23: p_parameter_string IN VARCHAR2
24: ,p_token IN VARCHAR2
25: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
26: IS
27: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
28: l_start_pos NUMBER;
29: l_delimiter VARCHAR2(1):=' ';
30: l_proc VARCHAR2(40):= g_package||' get parameter ';
31: BEGIN

Line 99: FROM pay_payroll_actions

95: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'DUE_DATE'))
96: ,PAY_FI_ARCHIVE_MTRA.GET_PARAMETER(legislative_parameters,'REF_NUMBER')
97: ,effective_date
98: ,business_group_id
99: FROM pay_payroll_actions
100: WHERE payroll_action_id = p_payroll_action_id;
101: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
102: --
103: BEGIN

Line 392: from pay_payroll_actions appa,

388: select paaf.person_id, act.assignment_id assignment_id, act.assignment_action_id run_action_id,
389: act1.assignment_action_id
390: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
391: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
392: from pay_payroll_actions appa,
393: pay_payroll_actions appa2,
394: pay_assignment_actions act,
395: pay_assignment_actions act1,
396: pay_action_interlocks pai,

Line 393: pay_payroll_actions appa2,

389: act1.assignment_action_id
390: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
391: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
392: from pay_payroll_actions appa,
393: pay_payroll_actions appa2,
394: pay_assignment_actions act,
395: pay_assignment_actions act1,
396: pay_action_interlocks pai,
397: per_all_assignments_f paaf,

Line 494: ,pay_payroll_actions ppa

490: END IF;
491:
492: p_sql := 'SELECT DISTINCT person_id
493: FROM per_people_f ppf
494: ,pay_payroll_actions ppa
495: WHERE ppa.payroll_action_id = :payroll_action_id
496: AND ppa.business_group_id = ppf.business_group_id
497: ORDER BY ppf.person_id';
498: