DBA Data[Home] [Help]

APPS.PAY_IE_ARCHIVE_DETAIL_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 206: FROM pay_all_payrolls_f papf

202: CURSOR CSR_PAYROLLS
203: IS
204: SELECT count(distinct org_information8) paycount,
205: org_information8
206: FROM pay_all_payrolls_f papf
207: , hr_organization_information org
208: , hr_soft_coding_keyflex sck
209: WHERE
210: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

Line 240: , pay_all_payrolls_f papf

236: and org.ORG_INFORMATION_ID =
237: (SELECT to_number(segment2)
238: FROM
239: hr_soft_coding_keyflex sck
240: , pay_all_payrolls_f papf
241: , pay_payroll_actions ppa
242: WHERE
243: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
244: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')