APPS.PQH_FR_QUOTA_CHECK dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 265: From ben_elig_per_elctbl_chc elc, ben_per_in_ler pil,

261: elc.pgm_id program_id,
262: grades.grade_id grade_id,
263: grades.name grade_name,
264: pil.business_group_id business_group_id
265: From ben_elig_per_elctbl_chc elc, ben_per_in_ler pil,
266: ben_pl_f pl, per_grades grades,
267: pqh_corps_definitions corp
268: Where elc.elig_per_elctbl_chc_id = l_elctbl_chc_id
269: and elc.per_in_ler_id = pil.per_in_ler_id

Line 375: from ben_elig_per_elctbl_chc elc,

371: p_effective_date => g_quota_grid(table_row).effective_date);
372:
373: select count(elc.elig_per_elctbl_chc_id )
374: into l_already_app
375: from ben_elig_per_elctbl_chc elc,
376: ben_per_in_ler pil,
377: ben_pl_f pl,
378: pqh_corps_definitions corp
379: where nvl(elc.approval_status_cd,'PQH_GSP_NP') = 'PQH_GSP_NP'

Line 476: from ben_elig_per_elctbl_chc elc,

472: p_effective_date => p_effective_date);
473:
474: select count(elc.elig_per_elctbl_chc_id )
475: into l_already_app
476: from ben_elig_per_elctbl_chc elc,
477: ben_per_in_ler pil,
478: ben_pl_f pl,
479: pqh_corps_definitions corp
480: where elc.approval_status_cd = 'PQH_GSP_A'