APPS.IEX_DUNNING_PVT dependencies on JTF_FM_QUERY

Line 13040: FROM jtf_FM_query_mes mes,

13036: AND primary_flag = 'Y';
13037: --
13038: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
13039: SELECT mes.query_id
13040: FROM jtf_FM_query_mes mes,
13041: jtf_FM_query q
13042: WHERE mes.MES_DOC_ID = in_mes_doc_id
13043: AND mes.query_id = q.query_id;
13044: --

Line 13041: jtf_FM_query q

13037: --
13038: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
13039: SELECT mes.query_id
13040: FROM jtf_FM_query_mes mes,
13041: jtf_FM_query q
13042: WHERE mes.MES_DOC_ID = in_mes_doc_id
13043: AND mes.query_id = q.query_id;
13044: --
13045: l_api_name CONSTANT VARCHAR2(30) := 'Call_FFM';

Line 13469: || jtf_FM_query_mes

13465: || p_method = Fulfillment Type, currently only 'EMAIL' is supported
13466: || p_party_id = pk to hz_parties
13467: ||
13468: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
13469: || jtf_FM_query_mes
13470: || jtf_FM_query
13471: ||
13472: || Target Tables:
13473: ||

Line 13470: || jtf_FM_query

13466: || p_party_id = pk to hz_parties
13467: ||
13468: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
13469: || jtf_FM_query_mes
13470: || jtf_FM_query
13471: ||
13472: || Target Tables:
13473: ||
13474: || Creation date: 03/07/02 11:36:AM

Line 13532: FROM jtf_FM_query_mes mes,

13528: AND primary_flag = 'Y';
13529: --
13530: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
13531: SELECT mes.query_id
13532: FROM jtf_FM_query_mes mes,
13533: jtf_FM_query q
13534: WHERE mes.MES_DOC_ID = in_mes_doc_id
13535: AND mes.query_id = q.query_id;
13536: --

Line 13533: jtf_FM_query q

13529: --
13530: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
13531: SELECT mes.query_id
13532: FROM jtf_FM_query_mes mes,
13533: jtf_FM_query q
13534: WHERE mes.MES_DOC_ID = in_mes_doc_id
13535: AND mes.query_id = q.query_id;
13536: --
13537: l_api_name CONSTANT VARCHAR2(30) := 'Send_Fulfillment';