APPS.PAAPIMP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 3191: from hr_organization_units org1,

3187: Begin
3188:
3189: select org2.business_group_id
3190: into G_PER_BUS_GRP_ID
3191: from hr_organization_units org1,
3192: hr_organization_units org2
3193: Where org1.organization_id = l_exp_org_id_tbl(i)
3194: and org1.business_group_id = org2.organization_id ;
3195:

Line 3192: hr_organization_units org2

3188:
3189: select org2.business_group_id
3190: into G_PER_BUS_GRP_ID
3191: from hr_organization_units org1,
3192: hr_organization_units org2
3193: Where org1.organization_id = l_exp_org_id_tbl(i)
3194: and org1.business_group_id = org2.organization_id ;
3195:
3196: Exception

Line 5195: from hr_organization_units org1,

5191: Begin
5192:
5193: select org2.business_group_id
5194: into G_PER_BUS_GRP_ID
5195: from hr_organization_units org1,
5196: hr_organization_units org2
5197: Where org1.organization_id = l_exp_org_id_tbl(i)
5198: and org1.business_group_id = org2.organization_id;
5199:

Line 5196: hr_organization_units org2

5192:
5193: select org2.business_group_id
5194: into G_PER_BUS_GRP_ID
5195: from hr_organization_units org1,
5196: hr_organization_units org2
5197: Where org1.organization_id = l_exp_org_id_tbl(i)
5198: and org1.business_group_id = org2.organization_id;
5199:
5200: EXCEPTION

Line 8200: from hr_organization_units org1,

8196: Begin
8197:
8198: select org2.business_group_id
8199: into G_PER_BUS_GRP_ID
8200: from hr_organization_units org1,
8201: hr_organization_units org2
8202: Where org1.organization_id = l_exp_org_id_tbl(i)
8203: and org1.business_group_id = org2.organization_id;
8204:

Line 8201: hr_organization_units org2

8197:
8198: select org2.business_group_id
8199: into G_PER_BUS_GRP_ID
8200: from hr_organization_units org1,
8201: hr_organization_units org2
8202: Where org1.organization_id = l_exp_org_id_tbl(i)
8203: and org1.business_group_id = org2.organization_id;
8204:
8205: EXCEPTION

Line 9977: from hr_organization_units org1,

9973: Begin
9974:
9975: select org2.business_group_id
9976: into G_PER_BUS_GRP_ID
9977: from hr_organization_units org1,
9978: hr_organization_units org2
9979: Where org1.organization_id = l_exp_org_id_tbl(i)
9980: and org1.business_group_id = org2.organization_id ;
9981:

Line 9978: hr_organization_units org2

9974:
9975: select org2.business_group_id
9976: into G_PER_BUS_GRP_ID
9977: from hr_organization_units org1,
9978: hr_organization_units org2
9979: Where org1.organization_id = l_exp_org_id_tbl(i)
9980: and org1.business_group_id = org2.organization_id ;
9981:
9982: Exception