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_BEN_VALIDATIONS dependencies on BEN_OPT_F

Line 443: BEN_OPT_F opt,

439: IS
440: Select pl.MAPPING_TABLE_PK_ID, -- Grade_Id
441: opt.MAPPING_TABLE_PK_ID -- spinal_point_id
442: From BEN_OIPL_F oipl,
443: BEN_OPT_F opt,
444: BEN_PL_F pl
445: Where oipl.Oipl_Id = p_oipl_id
446: And oipl.OIPL_STAT_CD = 'A'
447: And oipl.Pl_id = pl.PL_ID

Line 835: FROM BEN_OPT_F opt,

831:
832: Cursor csr_opt_in_pl
833: IS
834: Select Null
835: FROM BEN_OPT_F opt,
836: BEN_OIPL_F oipl,
837: BEN_PL_F pl
838: WHERE opt.opt_id = p_opt_id
839: AND opt.Business_group_id = p_Business_Group_Id

Line 912: FROM BEN_OPT_F opt,

908:
909: Cursor csr_pl_id
910: IS
911: Select oipl.PL_ID
912: FROM BEN_OPT_F opt,
913: BEN_OIPL_F oipl
914: WHERE opt.opt_id = p_opt_id
915: AND opt.Business_group_id = p_Business_Group_Id
916: AND opt.opt_id = oipl.opt_id