APPS.IEC_CPN_RLSE_STTGY_PVT dependencies on IEC_G_SUBSET_RT_INFO

Line 237: EXECUTE IMMEDIATE 'update iec_g_subset_rt_info ' ||

233: PRAGMA AUTONOMOUS_TRANSACTION;
234:
235: BEGIN
236:
237: EXECUTE IMMEDIATE 'update iec_g_subset_rt_info ' ||
238: 'set working_quantum = :1 ' ||
239: ', use_flag = :2 ' ||
240: ', working_quota = :3 ' ||
241: ', quota_reset_time = :4 ' ||

Line 304: , iec_g_subset_rt_info b

300: from iec_g_mktg_item_cc_tzs
301: where subset_id in
302: ( select a.list_Subset_id
303: from iec_g_list_Subsets a
304: , iec_g_subset_rt_info b
305: where a.list_header_id = L_LIST_ID
306: and a.list_subset_id = b.list_subset_id
307: and b.working_quota > 0
308: and b.status_code = 'ACTIVE')

Line 477: , iec_g_subset_rt_info b

473: from iec_g_mktg_item_cc_tzs
474: where subset_id in
475: ( select a.list_Subset_id
476: from iec_g_list_Subsets a
477: , iec_g_subset_rt_info b
478: where a.list_header_id = L_LIST_ID
479: and a.list_subset_id = b.list_subset_id
480: and b.working_quota > 0
481: and b.status_code = 'ACTIVE')

Line 835: , iec_g_subset_rt_info b

831: , l_quota_reset_time_tbl
832: , l_use_flag_tbl
833: , l_quota_reset_tbl
834: FROM iec_g_list_subsets a
835: , iec_g_subset_rt_info b
836: WHERE a.list_header_id = P_LIST_HEADER_ID
837: AND a.list_subset_id = b.list_subset_id
838: AND b.valid_flag = 'Y'
839: AND b.callable_flag = 'Y'