APPS.IES_DEPLOYED_SCRIPTS_PVT dependencies on IES_TRANSACTIONS

Line 123: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);

119: -- Standard Start of API savepoint
120: SAVEPOINT Delete_Deployed_Scripts_PVT;
121:
122: delete from ies_question_data where transaction_id in
123: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);
124:
125: delete from ies_panel_data where transaction_id in
126: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);
127:

Line 126: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);

122: delete from ies_question_data where transaction_id in
123: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);
124:
125: delete from ies_panel_data where transaction_id in
126: (select transaction_id from ies_transactions where dscript_id = p_dscript_id);
127:
128: delete from ies_questions where panel_id in
129: (select panel_id from ies_panels where dscript_id = p_dscript_id);
130:

Line 134: delete from ies_transactions where dscript_id = p_dscript_id;

130:
131: delete from ies_answers where lookup_id in
132: (select lookup_id from ies_lookups where dscript_id = p_dscript_id);
133:
134: delete from ies_transactions where dscript_id = p_dscript_id;
135:
136: delete from ies_lookups where dscript_id = p_dscript_id;
137:
138: delete from ies_panels where dscript_id = p_dscript_id;