APPS.IEX_DUNNING_PVT dependencies on JTF_FM_QUERY

Line 5987: FROM jtf_FM_query_mes mes,

5983: AND primary_flag = 'Y';
5984: --
5985: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
5986: SELECT mes.query_id
5987: FROM jtf_FM_query_mes mes,
5988: jtf_FM_query q
5989: WHERE mes.MES_DOC_ID = in_mes_doc_id
5990: AND mes.query_id = q.query_id;
5991: --

Line 5988: jtf_FM_query q

5984: --
5985: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
5986: SELECT mes.query_id
5987: FROM jtf_FM_query_mes mes,
5988: jtf_FM_query q
5989: WHERE mes.MES_DOC_ID = in_mes_doc_id
5990: AND mes.query_id = q.query_id;
5991: --
5992: l_api_name CONSTANT VARCHAR2(30) := 'Call_FFM';

Line 6412: || jtf_FM_query_mes

6408: || p_method = Fulfillment Type, currently only 'EMAIL' is supported
6409: || p_party_id = pk to hz_parties
6410: ||
6411: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
6412: || jtf_FM_query_mes
6413: || jtf_FM_query
6414: ||
6415: || Target Tables:
6416: ||

Line 6413: || jtf_FM_query

6409: || p_party_id = pk to hz_parties
6410: ||
6411: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
6412: || jtf_FM_query_mes
6413: || jtf_FM_query
6414: ||
6415: || Target Tables:
6416: ||
6417: || Creation date: 03/07/02 11:36:AM

Line 6475: FROM jtf_FM_query_mes mes,

6471: AND primary_flag = 'Y';
6472: --
6473: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
6474: SELECT mes.query_id
6475: FROM jtf_FM_query_mes mes,
6476: jtf_FM_query q
6477: WHERE mes.MES_DOC_ID = in_mes_doc_id
6478: AND mes.query_id = q.query_id;
6479: --

Line 6476: jtf_FM_query q

6472: --
6473: CURSOR C_GET_CONTENT_TYPE (IN_MES_DOC_ID NUMBER) IS
6474: SELECT mes.query_id
6475: FROM jtf_FM_query_mes mes,
6476: jtf_FM_query q
6477: WHERE mes.MES_DOC_ID = in_mes_doc_id
6478: AND mes.query_id = q.query_id;
6479: --
6480: l_api_name CONSTANT VARCHAR2(30) := 'Send_Fulfillment';