APPS.PQH_BPR_BUS dependencies on PER_TIME_PERIODS

Line 111: from per_time_periods a

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

Line 127: -- check if end_time_period_id value exists in per_time_periods table

123: and nvl(p_end_time_period_id,hr_api.g_number)
124: <> nvl(pqh_bpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if end_time_period_id value exists in per_time_periods table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

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

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in per_time_periods
137: -- table.
138: --
139: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK3');
140: --

Line 186: from per_time_periods a

182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from per_time_periods a
187: where a.time_period_id = p_start_time_period_id;
188: --
189: Begin
190: --

Line 202: -- check if start_time_period_id value exists in per_time_periods table

198: and nvl(p_start_time_period_id,hr_api.g_number)
199: <> nvl(pqh_bpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if start_time_period_id value exists in per_time_periods table
203: --
204: open c1;
205: --
206: fetch c1 into l_dummy;

Line 211: -- raise error as FK does not relate to PK in per_time_periods

207: if c1%notfound then
208: --
209: close c1;
210: --
211: -- raise error as FK does not relate to PK in per_time_periods
212: -- table.
213: --
214: pqh_bpr_shd.constraint_error('PQH_BUDGET_PERIODS_FK2');
215: --