APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_PAYROLL_ACTIONS

Line 72: FROM pay_payroll_actions ppa

68: ,'TRANSFER_BATCH_REF_NO=P', pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'BATCH_REF_NO')
69: ,'TRANSFER_PARTY_NAME=P', hou.name
70: ,'TRANSFER_CATG_PURP=P', NVL(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'SEPA_CATEGORY'),'SALA')
71: --15971893
72: FROM pay_payroll_actions ppa
73: ,pay_org_payment_methods_f popmf --15971893
74: ,hr_all_organization_units hou --15971893
75: WHERE ppa.payroll_action_id =
76: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 110: PAY_PAYROLL_ACTIONS ppa,

106: pay_org_payment_methods_f popmf,
107: PAY_ORG_PAY_METHOD_USAGES_F popmu,
108: PAY_ALL_PAYROLLS_F papf,
109: PAY_EXTERNAL_ACCOUNTS pea,
110: PAY_PAYROLL_ACTIONS ppa,
111: pay_payment_types ppt
112: -- hr_soft_coding_keyflex hsck
113: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
114: and hou.business_group_id = ppa.business_group_id

Line 189: ,pay_payroll_actions ppa

185: ,per_all_people_f pef
186: ,pay_all_payrolls_f ppf
187: ,pay_pre_payments ppp
188: ,pay_assignment_actions paa
189: ,pay_payroll_actions ppa
190: ,pay_personal_payment_methods_f ppmf
191: ,pay_external_accounts pea
192: --,hr_soft_coding_keyflex hsck
193: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')