APPS.BEN_XER_SHD dependencies on BEN_EXT_WHERE_CLAUSE

Line 76: ben_ext_where_clause xwc

72: cursor c5 is
73: select xfi.name
74: from ben_ext_file xfi,
75: ben_ext_rcd_in_file xrf,
76: ben_ext_where_clause xwc
77: where xwc.cond_ext_data_elmt_in_rcd_id = g_old_rec.ext_data_elmt_in_rcd_id
78: and xwc.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id
79: and xrf.ext_file_id = xfi.ext_file_id;
80:

Line 108: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then

104: fnd_message.set_token('STEP','20');
105: fnd_message.raise_error;
106: ElsIf (p_constraint_name = 'BEN_EXT_INCL_CHG_FK1') Then
107: ben_utility.child_exists_error(p_table_name => 'BEN_EXT_INCL_CHG');
108: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
109: fnd_message.set_name('BEN', 'BEN_92479_XWC_EXISTS');
110: fnd_message.raise_error;
111: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK4') Then
112: open c1;

Line 139: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then

135: close c4;
136: fnd_message.set_name('BEN', 'BEN_92478_ELMT_REF_IN_SORT');
137: fnd_message.set_token('FILE_NAME', l_name);
138: fnd_message.raise_error;
139: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
140: open c5;
141: fetch c5 into l_name;
142: if c5%found then
143: close c5;