APPS.BEN_EXT_PERSON dependencies on BEN_EXT_CRIT_VAL

Line 41: ben_ext_crit_val ecv,

37: ecc.oper_cd,
38: ecc.val_1,
39: ecc.val_2
40: from ben_ext_crit_typ ect,
41: ben_ext_crit_val ecv,
42: ben_ext_crit_cmbn ecc
43: where ect.crit_typ_cd = 'ADV'
44: and ect.ext_crit_typ_id = ecv.ext_crit_typ_id
45: and ect.ext_crit_prfl_id = p_ext_crit_prfl_id

Line 2667: ,ben_ext_crit_val xcv

2663:
2664: cursor c_chg_pay_evt is
2665: select xcv.val_1 event_group_id
2666: from ben_ext_crit_typ xct
2667: ,ben_ext_crit_val xcv
2668: where xct.ext_crit_prfl_id = p_ext_crit_prfl_id
2669: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
2670: and xct.CRIT_TYP_CD = 'CPE'
2671: ;