DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 4763: hr_organization_information hoi

4759: select /*+ ORDERED */
4760: hoi.rowid row_id
4761: from per_business_groups_perf pbg,
4762: hr_all_organization_units hou,
4763: hr_organization_information hoi
4764: where pbg.legislation_code = 'JP'
4765: and hou.business_group_id = pbg.business_group_id
4766: and hoi.organization_id = hou.organization_id
4767: and hoi.org_information_context = p_org_information_context

Line 4784: update hr_organization_information

4780: --
4781: fetch csr_org_df into l_csr_org_df;
4782: exit when csr_org_df%notfound;
4783: --
4784: update hr_organization_information
4785: set org_information3 = p_org_information3_n
4786: where rowid = l_csr_org_df.row_id;
4787: --
4788: if l_cnt > 1000 then

Line 4832: hr_organization_information hoi

4828: select /*+ ORDERED */
4829: count(hoi.org_information_id)
4830: from per_business_groups_perf pbg,
4831: hr_all_organization_units hou,
4832: hr_organization_information hoi
4833: where pbg.legislation_code = 'JP'
4834: and hou.business_group_id = pbg.business_group_id
4835: and hoi.organization_id = hou.organization_id
4836: and hoi.org_information_context in (