APPS.PQH_WFS_BUS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 111: from pay_cost_allocation_keyflex a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from pay_cost_allocation_keyflex a
112: where a.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
113: --
114: Begin
115: --

Line 127: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table

123: and nvl(p_cost_allocation_keyflex_id,hr_api.g_number)
124: <> nvl(pqh_wfs_shd.g_old_rec.cost_allocation_keyflex_id,hr_api.g_number)
125: or not l_api_updating) and p_cost_allocation_keyflex_id is not null then
126: --
127: -- check if cost_allocation_keyflex_id value exists in pay_cost_allocation_keyflex table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in pay_cost_allocation_keyflex

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in pay_cost_allocation_keyflex
137: -- table.
138: --
139: hr_utility.set_message(8302,'PQH_INVALID_COST_KEYFLEX');
140: hr_utility.raise_error;