APPS.PER_SUB_BUS dependencies on PER_QUALIFICATIONS

Line 79: -- a foreign key to the PER_QUALIFICATIONS table and so must be populated

75: -- |---------------------------< chk_qualification_id >-----------------------|
76: -- ----------------------------------------------------------------------------
77: -- Description
78: -- This procedure checks that the qualification_id is not null. This is
79: -- a foreign key to the PER_QUALIFICATIONS table and so must be populated
80: -- on insert and on update.
81: --
82: -- Pre-Conditions
83: -- None.

Line 109: from per_qualifications per

105: l_dummy varchar2(1);
106: --
107: cursor c1 is
108: select null
109: from per_qualifications per
110: where per.qualification_id = p_qualification_id;
111: --
112: Begin
113: --

Line 125: -- check if qualification id exists in per_qualifications table.

121: and nvl(p_qualification_id,hr_api.g_number)
122: <> per_sub_shd.g_old_rec.qualification_id
123: or not l_api_updating) then
124: --
125: -- check if qualification id exists in per_qualifications table.
126: -- it must also be a not null value.
127: --
128: open c1;
129: --

Line 197: from per_qualifications per

193: -- Validation of qualification end date against subject
194: -- start date and end date is relaxed.
195: cursor c1 is
196: select null
197: from per_qualifications per
198: where per.qualification_id = p_qualification_id
199: and p_start_date between nvl(per.start_date,hr_api.g_sot)
200: and nvl(per.end_date,p_start_date)
201: and (p_start_date <= nvl(per.end_date,hr_api.g_eot));

Line 208: from per_qualifications per

204: Begin
205: --
206: select start_date,end_date
207: into l_start_date,l_end_date
208: from per_qualifications per
209: where per.qualification_id = p_qualification_id;
210: --
211: hr_utility.set_location('Entering:'||l_proc,5);
212: --

Line 322: from per_qualifications per

318: -- start date and end date is relaxed.
319:
320: cursor c1 is
321: select null
322: from per_qualifications per
323: where per.qualification_id = p_qualification_id
324: and nvl(p_end_date,nvl(per.end_date,hr_api.g_eot))
325: between nvl(per.start_date,hr_api.g_sot)
326: and nvl(per.end_date,hr_api.g_eot);

Line 333: from per_qualifications per

329: Begin
330: --
331: select end_date
332: into l_end_date
333: from per_qualifications per
334: where per.qualification_id = p_qualification_id;
335: --
336: hr_utility.set_location('Entering:'||l_proc,5);
337: --