APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_PAYROLL_ACTIONS

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

7: p_parameter_string IN VARCHAR2
8: ,p_token IN VARCHAR2
9: ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2
10: IS
11: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
12: l_start_pos NUMBER;
13: l_delimiter varchar2(1):=' ';
14: l_proc VARCHAR2(60):= g_package||' get parameter ';
15: BEGIN

Line 57: pay_payroll_actions ppa

53:
54: p_sqlstr := 'SELECT distinct asg.person_id
55: FROM per_periods_of_service pos,
56: per_assignments_f asg,
57: pay_payroll_actions ppa
58: WHERE ppa.payroll_action_id = :payroll_action_id
59: AND pos.person_id = asg.person_id
60: AND pos.period_of_service_id = asg.period_of_service_id
61: AND pos.business_group_id = ppa.business_group_id

Line 94: pay_payroll_actions pa2,

90: act.assignment_id,
91: ppp.pre_payment_id
92: FROM pay_assignment_actions act,
93: per_all_assignments_f asg,
94: pay_payroll_actions pa2,
95: pay_payroll_actions pa1,
96: pay_pre_payments ppp,
97: pay_org_payment_methods_f OPM,
98: pay_payment_types PPT,

Line 95: pay_payroll_actions pa1,

91: ppp.pre_payment_id
92: FROM pay_assignment_actions act,
93: per_all_assignments_f asg,
94: pay_payroll_actions pa2,
95: pay_payroll_actions pa1,
96: pay_pre_payments ppp,
97: pay_org_payment_methods_f OPM,
98: pay_payment_types PPT,
99: per_all_people_f pap

Line 128: pay_payroll_actions appa

124: ))
125: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
126: FROM pay_action_interlocks pai1,
127: pay_assignment_actions act2,
128: pay_payroll_actions appa
129: WHERE pai1.locked_action_id = act.assignment_action_id
130: AND act2.assignment_action_id = pai1.locking_action_id
131: AND act2.payroll_action_id = appa.payroll_action_id
132: AND appa.action_type = 'X'

Line 439: PAY_PAYROLL_ACTIONS ppa,

435: pay_org_payment_methods_f popmf,
436: PAY_ORG_PAY_METHOD_USAGES_F popmu,
437: PAY_ALL_PAYROLLS_F papf,
438: PAY_EXTERNAL_ACCOUNTS pea,
439: PAY_PAYROLL_ACTIONS ppa,
440: hr_soft_coding_keyflex hsck
441: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
442: and hou.business_group_id = ppa.business_group_id
443: and hoi.org_information_context(+) = 'IE_PAYPATH_INFORMATION'

Line 493: ,pay_payroll_actions ppa

489: ,per_all_people_f pef
490: ,pay_all_payrolls_f ppf
491: ,pay_pre_payments ppp
492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa
494: ,pay_personal_payment_methods_f ppmf
495: ,pay_external_accounts pea
496: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
497: AND paa.pre_payment_id = ppp.pre_payment_id