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_GSP_DEFAULT dependencies on BEN_PLIP_F

Line 395: from ben_plip_f

391: hr_utility.set_location('pl id is '||l_pl_id,10);
392: begin
393: select ordr_num
394: into l_ordr_num
395: from ben_plip_f
396: where pgm_id = p_gl_id
397: and p_effective_date between effective_start_date and effective_end_date
398: and pl_id = l_pl_id;
399: hr_utility.set_location('ordr num is '||l_ordr_num,20);

Line 699: from ben_plip_f

695: l_next_ordr_num number;
696: l_next_pl_id number;
697: cursor csr_plips is
698: select pl_id,ordr_num
699: from ben_plip_f
700: where pgm_id = p_gl_id
701: and p_effective_date between effective_start_date and effective_end_date
702: and plip_stat_cd ='A'
703: and ordr_num > l_ordr_num

Line 715: from ben_plip_f

711: hr_utility.set_location('getting next plan',10);
712: begin
713: select plip_id,ordr_num
714: into l_plip_id,l_ordr_num
715: from ben_plip_f
716: where pgm_id = p_gl_id
717: and p_effective_date between effective_start_date and effective_end_date
718: and plip_stat_cd ='A'
719: and pl_id = p_pl_id;