APPS.IEC_CPN_RLSE_STTGY_PVT dependencies on IEC_G_MKTG_ITEM_CC_TZS

Line 47: L_CALLABLE_FLAG IEC_G_MKTG_ITEM_CC_TZS.CALLABLE_FLAG%TYPE;

43: ,X_CALLBACK_RESTRICT_COUNT IN OUT NOCOPY NUMBER
44: )
45: AS
46:
47: L_CALLABLE_FLAG IEC_G_MKTG_ITEM_CC_TZS.CALLABLE_FLAG%TYPE;
48: L_STILL_CALLABLE BINARY_INTEGER;
49: L_CALLBACK_FLAG IEC_G_RETURN_ENTRIES.CALLBACK_FLAG%TYPE;
50: L_CHECKED_OUT_FLAG IEC_G_RETURN_ENTRIES.RECORD_OUT_FLAG%TYPE;
51: L_CALLBACK_EXPIRATION BINARY_INTEGER;

Line 74: , iec_g_mktg_item_Cc_tzs b

70: , a.record_out_flag
71: , c.status_code
72: , count(*)
73: from iec_g_return_entries a
74: , iec_g_mktg_item_Cc_tzs b
75: , iec_g_list_subsets c
76: where a.list_header_id = L_LIST_ID
77: and a.list_header_id = c.list_header_id
78: and a.itm_cc_Tz_id = b.itm_cc_tz_id

Line 300: from iec_g_mktg_item_cc_tzs

296: from iec_g_return_entries d
297: , iec_g_list_subsets c
298: where itm_cc_tz_id in
299: ( select itm_cc_tz_id
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

Line 473: from iec_g_mktg_item_cc_tzs

469: from iec_g_return_entries d
470: , iec_g_list_subsets c
471: where itm_cc_tz_id in
472: ( select itm_cc_tz_id
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

Line 645: from iec_g_mktg_item_cc_tzs

641: returns_id
642: from iec_g_return_entries
643: where itm_cc_tz_id in
644: ( select itm_cc_tz_id
645: from iec_g_mktg_item_cc_tzs
646: where subset_id = L_SUBSET_ID
647: and nvl(callable_flag, 'Y') <> 'N'
648: and last_callable_time > sysdate)
649: and nvl( callback_flag, 'N') = 'N'