APPS.IEX_DUNNING_PVT dependencies on JTF_FM_TEMPLATE_CONTENTS

Line 13019: FROM JTF_FM_TEMPLATE_CONTENTS

13015: CURSOR C_GET_CONTENTS (IN_TEMPLATE_ID NUMBER) IS
13016: SELECT --content_NUMBER,
13017: upper(substr(content_name,instr(content_name,'.')+1,length(content_name)-instr(content_name,'.'))) DocType,
13018: mes_doc_ID
13019: FROM JTF_FM_TEMPLATE_CONTENTS
13020: WHERE template_ID = in_template_ID
13021: AND nvl(upper(f_deletedflag),'0') <>'D'
13022: --bug 3090268
13023: --ORDER BY content_number;

Line 13468: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,

13464: || p_template_id = fulfillment template
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:

Line 13511: FROM JTF_FM_TEMPLATE_CONTENTS

13507: CURSOR C_GET_CONTENTS (IN_TEMPLATE_ID NUMBER) IS
13508: SELECT --content_NUMBER,
13509: upper(substr(content_name,instr(content_name,'.')+1,length(content_name)-instr(content_name,'.'))) DocType,
13510: mes_doc_ID
13511: FROM JTF_FM_TEMPLATE_CONTENTS
13512: WHERE template_ID = in_template_ID
13513: AND nvl(upper(f_deletedflag),'0') <>'D'
13514: --bug 3090268
13515: --ORDER BY content_number;