DBA Data[Home] [Help]

APPS.PAY_IE_ARCHIVE_DETAIL_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 207: , hr_organization_information org

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

Line 222: FROM hr_organization_information org

218: --Cursor to fetch first paypath id defined at BG Level
219: CURSOR CSR_BG_PAYPATH
220: IS
221: SELECT org.org_information8
222: FROM hr_organization_information org
223: , pay_payroll_actions ppa
224: WHERE
225: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
226: and org.organization_id = ppa.business_group_id

Line 233: FROM hr_organization_information org

229: --Cursor to fetch paypath id for a specified payroll parameter
230: CURSOR CSR_PAYROLL_PAYPATH
231: IS
232: SELECT org.org_information8
233: FROM hr_organization_information org
234: WHERE
235: org.org_information_context = 'IE_PAYPATH_INFORMATION'
236: and org.ORG_INFORMATION_ID =
237: (SELECT to_number(segment2)