APPS.PQH_PRE_BUS dependencies on PQH_DE_INS_END_REASONS

Line 30: , pqh_de_ins_end_reasons pre

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_ins_end_reasons pre
31: where pre.ins_end_reason_id = p_ins_end_reason_id
32: and pbg.business_group_id = pre.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_ins_end_reasons pre

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_ins_end_reasons pre
95: where pre.ins_end_reason_id = p_ins_end_reason_id
96: and pbg.business_group_id = pre.business_group_id;
97: --
98: -- Declare local variables

Line 213: from pqh_de_ins_end_reasons

209: (p_rec in pqh_pre_shd.g_rec_type) is
210: --
211: Cursor c_END_REASON_NUMBER is
212: Select END_REASON_NUMBER
213: from pqh_de_ins_end_reasons
214: Where PROVIDER_ORGANIZATION_ID = p_rec.PROVIDER_ORGANIZATION_ID
215: and END_REASON_NUMBER = p_rec.END_REASON_NUMBER;
216: l_END_REASON_NUMBER pqh_de_ins_end_reasons.END_REASON_NUMBER%TYPE;
217: l_proc varchar2(72) := g_package || 'Unique_END_REASON_NUMBER';

Line 216: l_END_REASON_NUMBER pqh_de_ins_end_reasons.END_REASON_NUMBER%TYPE;

212: Select END_REASON_NUMBER
213: from pqh_de_ins_end_reasons
214: Where PROVIDER_ORGANIZATION_ID = p_rec.PROVIDER_ORGANIZATION_ID
215: and END_REASON_NUMBER = p_rec.END_REASON_NUMBER;
216: l_END_REASON_NUMBER pqh_de_ins_end_reasons.END_REASON_NUMBER%TYPE;
217: l_proc varchar2(72) := g_package || 'Unique_END_REASON_NUMBER';
218: Begin
219:
220: hr_utility.set_location(l_proc, 10);

Line 232: (p_associated_column1 => 'pqh_de_ins_end_reasons.END_REASON_NUMBER'

228: Close c_END_REASON_NUMBER;
229: Exception
230: when app_exception.application_exception then
231: if hr_multi_message.exception_add
232: (p_associated_column1 => 'pqh_de_ins_end_reasons.END_REASON_NUMBER'
233: ) then
234: hr_utility.set_location(' Leaving:'||l_proc,60);
235: raise;
236: end if;