DBA Data[Home] [Help]

APPS.PY_ZA_TAX_CERTIFICATES dependencies on PAY_ALL_PAYROLLS_F

Line 135: pay_all_payrolls_f ppf,

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

Line 169: from pay_all_payrolls_f ppf2

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