APPS.JTF_FM_UTL_V dependencies on JTF_FM_REQUEST_CONTENTS

Line 27: SELECT DISTINCT(CONTENT_NUMBER) c_num FROM JTF_FM_REQUEST_CONTENTS

23: l_found BOOLEAN;
24:
25: CURSOR CCONTNUM(p_request_id NUMBER) IS
26:
27: SELECT DISTINCT(CONTENT_NUMBER) c_num FROM JTF_FM_REQUEST_CONTENTS
28: WHERE REQUEST_ID = p_request_id;
29:
30: CURSOR CDOCTYPE(p_request_id NUMBER,
31: l_content_number NUMBER) IS

Line 33: SELECT DOCUMENT_TYPE FROM JTF_FM_REQUEST_CONTENTS

29:
30: CURSOR CDOCTYPE(p_request_id NUMBER,
31: l_content_number NUMBER) IS
32:
33: SELECT DOCUMENT_TYPE FROM JTF_FM_REQUEST_CONTENTS
34: WHERE REQUEST_ID = p_request_id AND CONTENT_NUMBER = l_content_number;
35:
36: BEGIN
37: --