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.PQP_GB_OSP_FUNCTIONS dependencies on BEN_PL_F

Line 103: FROM pay_element_type_extra_info petei, ben_pl_f bpl, ben_pl_typ_f bpty

99: ,p_information_type IN VARCHAR2
100: )
101: IS
102: SELECT petei.element_type_id
103: FROM pay_element_type_extra_info petei, ben_pl_f bpl, ben_pl_typ_f bpty
104: WHERE UPPER(petei.eei_information19) = 'ABSENCE INFO'
105: AND petei.information_type = p_information_type
106: --'PQP_GB_ABSENCE_PLAN_INFO'
107: AND bpl.pl_typ_id = bpty.pl_typ_id

Line 120: FROM ben_pl_f bpl, ben_pl_typ_f bpty

116: ,p_pl_name IN VARCHAR2
117: )
118: IS
119: SELECT bpl.pl_id
120: FROM ben_pl_f bpl, ben_pl_typ_f bpty
121: WHERE bpl.pl_typ_id = bpty.pl_typ_id
122: AND bpty.opt_typ_cd = 'ABS'
123: AND bpl.business_group_id = p_business_group_id
124: AND p_effective_date BETWEEN bpl.effective_start_date