DBA Data[Home] [Help]

APPS.PAY_IE_ARCHIVE_DETAIL_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 208: , hr_soft_coding_keyflex sck

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')
211: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
212: between papf.effective_start_date and papf.effective_end_date

Line 239: hr_soft_coding_keyflex sck

235: org.org_information_context = 'IE_PAYPATH_INFORMATION'
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