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.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_CMBN

Line 80: from ben_ext_crit_cmbn

76: cursor c2 (p_ext_crit_val_id number) is
77: select ext_crit_cmbn_id ,
78: object_version_number ,
79: LEGISLATION_CODE
80: from ben_ext_crit_cmbn
81: where ext_crit_val_id = p_ext_crit_val_id
82: ;
83:
84: l_proc varchar2(100) := 'BEN_EXT_SEED.delete_crit_adv_conditon' ;

Line 96: BEN_ext_crit_cmbn_API.delete_ext_crit_cmbn

92:
93: for k in c2(i.ext_crit_val_id)
94: Loop
95: --- celete adv crit combn values
96: BEN_ext_crit_cmbn_API.delete_ext_crit_cmbn
97: (p_validate => FALSE
98: ,p_EXT_CRIT_CMBN_ID => k.EXT_CRIT_CMBN_ID
99: ,p_LEGISLATION_CODE => k.LEGISLATION_CODE
100: ,p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER

Line 4339: FROM ben_ext_crit_cmbn

4335: END;
4336: BEGIN
4337: SELECT 'Y'
4338: INTO l_temp
4339: FROM ben_ext_crit_cmbn
4340: WHERE ext_crit_val_id = l_ext_crit_val_id
4341: AND crit_typ_cd = p_crit_typ_cd
4342: and oper_cd = p_oper_cd
4343: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)