eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_QUOTA_CHECK dependencies on PER_GRADES

Line 11: grade_name per_grades.name%type,

7: TYPE quota_rec IS
8: RECORD (corp_id number,
9: corp_name pqh_corps_definitions.name%type,
10: grade_id number,
11: grade_name per_grades.name%type,
12: cur_per_app number,
13: effective_date date);
14:
15: TYPE quota_grid_table IS TABLE OF quota_rec

Line 266: ben_pl_f pl, per_grades grades,

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
270: And grades.grade_id = pl.mapping_table_pk_id

Line 271: And pl.mapping_table_name = 'PER_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
270: And grades.grade_id = pl.mapping_table_pk_id
271: And pl.mapping_table_name = 'PER_GRADES'
272: and p_effective_date between pl.effective_start_date and pl.effective_end_date
273: And corp.ben_pgm_id = elc.pgm_id
274: And pl.pl_id = elc.pl_id
275: and PER_IN_LER_STAT_CD = 'STRTD';

Line 385: and pl.mapping_table_name = 'PER_GRADES'

381: and pil.per_in_ler_id = elc.per_in_ler_id
382: and pil.per_in_ler_stat_cd = 'STRTD'
383: and corp.corps_definition_id = g_quota_grid(table_row).corp_id
384: and elc.pgm_id = corp.ben_pgm_id
385: and pl.mapping_table_name = 'PER_GRADES'
386: and pl.mapping_table_pk_id = g_quota_grid(table_row).grade_id
387: and g_quota_grid(table_row).effective_date between pl.effective_start_date and pl.effective_end_date
388: and elc.pl_id = pl.pl_id
389: and elc.business_group_id = p_business_group_id;

Line 453: l_grade_name per_grades.name%type;

449: l_grade_cur_pop number;
450: l_quota_allowed number;
451: l_already_app number;
452: l_corp_name pqh_corps_definitions.name%type;
453: l_grade_name per_grades.name%type;
454: l_proc varchar2(60) := g_package||'check_quota 2';
455: l_return_status varchar2(1) := 'Y';
456: l_corp_id number;
457: Begin

Line 485: and pl.mapping_table_name = 'PER_GRADES'

481: and pil.per_in_ler_id = elc.per_in_ler_id
482: and pil.per_in_ler_stat_cd = 'STRTD'
483: and corp.corps_definition_id = l_corp_id
484: and elc.pgm_id = corp.ben_pgm_id
485: and pl.mapping_table_name = 'PER_GRADES'
486: and pl.mapping_table_pk_id = p_grade_id
487: and p_effective_date between pl.effective_start_date and pl.effective_end_date
488: and elc.pl_id = pl.pl_id
489: and elc.business_group_id = p_business_group_id;

Line 492: from per_grades where

488: and elc.pl_id = pl.pl_id
489: and elc.business_group_id = p_business_group_id;
490:
491: select name into l_grade_name
492: from per_grades where
493: grade_id = p_grade_id;
494:
495: if l_quota_allowed is not null then
496: if ((l_quota_allowed - (l_grade_cur_pop + l_already_app + 1)) < 0 ) then