APPS.PY_ZA_TAX_CERTIFICATES dependencies on PAY_ALL_PAYROLLS_F

Line 138: pay_all_payrolls_f ppf,

134: per_addresses adr,
135: per_all_assignments_f ass,
136: per_assignment_extra_info aei,
137: hr_soft_coding_keyflex scl,
138: pay_all_payrolls_f ppf,
139: hr_locations hrl,
140: hr_organization_information hoi,
141: hr_all_organization_units hou,
142: fnd_common_lookups fcl,

Line 172: from pay_all_payrolls_f ppf2

168: and ppf.payroll_id = ass.payroll_id
169: and ppf.effective_start_date =
170: (
171: select max(ppf2.effective_start_date)
172: from pay_all_payrolls_f ppf2
173: where ppf2.effective_start_date <= ppa.effective_date
174: and ppf2.payroll_id = ass.payroll_id
175: )
176: and scl.soft_coding_keyflex_id (+) = ppf.soft_coding_keyflex_id