DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 4923: hr_organization_information hoi

4919: select /*+ ORDERED */
4920: hoi.rowid row_id
4921: from per_business_groups_perf pbg,
4922: hr_all_organization_units hou,
4923: hr_organization_information hoi
4924: where pbg.legislation_code = 'JP'
4925: and hou.business_group_id = pbg.business_group_id
4926: and hoi.organization_id = hou.organization_id
4927: and hoi.org_information_context = p_org_information_context

Line 4944: update hr_organization_information

4940: --
4941: fetch csr_org_df into l_csr_org_df;
4942: exit when csr_org_df%notfound;
4943: --
4944: update hr_organization_information
4945: set org_information3 = p_org_information3_n
4946: where rowid = l_csr_org_df.row_id;
4947: --
4948: if l_cnt > 1000 then

Line 4992: hr_organization_information hoi

4988: select /*+ ORDERED */
4989: count(hoi.org_information_id)
4990: from per_business_groups_perf pbg,
4991: hr_all_organization_units hou,
4992: hr_organization_information hoi
4993: where pbg.legislation_code = 'JP'
4994: and hou.business_group_id = pbg.business_group_id
4995: and hoi.organization_id = hou.organization_id
4996: and hoi.org_information_context in (