APPS.PAY_PMA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 112: from hr_all_organization_units a

108: l_dummy varchar2(1);
109: --
110: cursor c1 is
111: select null
112: from hr_all_organization_units a
113: where a.organization_id = p_organization_id;
114: --
115: cursor c2 (p_org_id NUMBER) is
116: select null

Line 136: -- check if organization_id value exists in hr_all_organization_units table

132: and nvl(p_organization_id,hr_api.g_number)
133: <> nvl(pay_pma_shd.g_old_rec.organization_id,hr_api.g_number)
134: or not l_api_updating) then
135: --
136: -- check if organization_id value exists in hr_all_organization_units table
137: --
138: open c1;
139: --
140: fetch c1 into l_dummy;

Line 145: -- raise error as FK does not relate to PK in hr_all_organization_units

141: if c1%notfound then
142: --
143: close c1;
144: --
145: -- raise error as FK does not relate to PK in hr_all_organization_units
146: -- table.
147: --
148: pay_pma_shd.constraint_error('PAY_CA_PMED_ACCOUNTS_FK1');
149: --