DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_ALL_PAYROLLS_F

Line 108: PAY_ALL_PAYROLLS_F papf,

104: from hr_all_organization_units hou,
105: --hr_organization_information hoi, --15971893
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

Line 141: ,pay_all_payrolls_f ppf

137: SELECT 1
138: FROM pay_assignment_actions pas
139: ,pay_pre_payments ppp
140: ,per_all_assignments_f paaf
141: ,pay_all_payrolls_f ppf
142: -- ,hr_soft_coding_keyflex hsck
143: WHERE pas.payroll_action_id = ppa.payroll_action_id
144: AND ppp.pre_payment_id = pas.pre_payment_id
145: AND ppp.value > 0

Line 186: ,pay_all_payrolls_f ppf

182: ,'BIC_EE=P',nvl(min(pea.SEGMENT6),' ')
183: ,'NATIONAL_IDENTIFIER=P',min(pef.NATIONAL_IDENTIFIER)
184: FROM per_all_assignments_f paf
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