APPS.PAAPIMP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 4293: from hr_organization_units org1,

4289: Begin
4290:
4291: select org2.business_group_id
4292: into G_PER_BUS_GRP_ID
4293: from hr_organization_units org1,
4294: hr_organization_units org2
4295: Where org1.organization_id = l_exp_org_id_tbl(i)
4296: and org1.business_group_id = org2.organization_id ;
4297:

Line 4294: hr_organization_units org2

4290:
4291: select org2.business_group_id
4292: into G_PER_BUS_GRP_ID
4293: from hr_organization_units org1,
4294: hr_organization_units org2
4295: Where org1.organization_id = l_exp_org_id_tbl(i)
4296: and org1.business_group_id = org2.organization_id ;
4297:
4298: Exception

Line 6513: from hr_organization_units org1,

6509: Begin
6510:
6511: select org2.business_group_id
6512: into G_PER_BUS_GRP_ID
6513: from hr_organization_units org1,
6514: hr_organization_units org2
6515: Where org1.organization_id = l_exp_org_id_tbl(i)
6516: and org1.business_group_id = org2.organization_id;
6517:

Line 6514: hr_organization_units org2

6510:
6511: select org2.business_group_id
6512: into G_PER_BUS_GRP_ID
6513: from hr_organization_units org1,
6514: hr_organization_units org2
6515: Where org1.organization_id = l_exp_org_id_tbl(i)
6516: and org1.business_group_id = org2.organization_id;
6517:
6518: EXCEPTION

Line 9910: from hr_organization_units org1,

9906: Begin
9907:
9908: select org2.business_group_id
9909: into G_PER_BUS_GRP_ID
9910: from hr_organization_units org1,
9911: hr_organization_units org2
9912: Where org1.organization_id = l_exp_org_id_tbl(i)
9913: and org1.business_group_id = org2.organization_id;
9914:

Line 9911: hr_organization_units org2

9907:
9908: select org2.business_group_id
9909: into G_PER_BUS_GRP_ID
9910: from hr_organization_units org1,
9911: hr_organization_units org2
9912: Where org1.organization_id = l_exp_org_id_tbl(i)
9913: and org1.business_group_id = org2.organization_id;
9914:
9915: EXCEPTION

Line 11732: from hr_organization_units org1,

11728: Begin
11729:
11730: select org2.business_group_id
11731: into G_PER_BUS_GRP_ID
11732: from hr_organization_units org1,
11733: hr_organization_units org2
11734: Where org1.organization_id = l_exp_org_id_tbl(i)
11735: and org1.business_group_id = org2.organization_id ;
11736:

Line 11733: hr_organization_units org2

11729:
11730: select org2.business_group_id
11731: into G_PER_BUS_GRP_ID
11732: from hr_organization_units org1,
11733: hr_organization_units org2
11734: Where org1.organization_id = l_exp_org_id_tbl(i)
11735: and org1.business_group_id = org2.organization_id ;
11736:
11737: Exception