APPS.IBE_DSPMGRVALIDATION_GRP dependencies on JTF_AMV_ITEMS_B

Line 749: FROM JTF_AMV_ITEMS_B

745: CURSOR deliverable_type_cur( p_deliverable_id IN NUMBER,
746: p_item_type IN VARCHAR2 ) IS
747: -- SELECT item_id
748: SELECT 1
749: FROM JTF_AMV_ITEMS_B
750: WHERE item_id = p_deliverable_id and
751: deliverable_type_code = p_item_type ;
752:
753: CURSOR deliverable_type_app_cur( p_deliverable_id IN NUMBER,

Line 757: FROM JTF_AMV_ITEMS_B

753: CURSOR deliverable_type_app_cur( p_deliverable_id IN NUMBER,
754: p_item_type IN VARCHAR2, p_applicable_to IN VARCHAR2 ) IS
755: -- SELECT item_id
756: SELECT 1
757: FROM JTF_AMV_ITEMS_B
758: WHERE item_id = p_deliverable_id and
759: deliverable_type_code = p_item_type and
760: (applicable_to_code = p_applicable_to OR
761: applicable_to_code = 'GENERIC');

Line 827: FROM JTF_AMV_ITEMS_B

823:
824: CURSOR deliverable_cur( p_deliverable_id IN NUMBER ) IS
825: -- SELECT item_id
826: SELECT 1
827: FROM JTF_AMV_ITEMS_B
828: WHERE item_id = p_deliverable_id;
829:
830: CURSOR deliverable_version_cur( p_deliverable_id IN NUMBER,
831: p_object_version_number IN NUMBER ) IS

Line 834: FROM JTF_AMV_ITEMS_B

830: CURSOR deliverable_version_cur( p_deliverable_id IN NUMBER,
831: p_object_version_number IN NUMBER ) IS
832: -- SELECT item_id
833: SELECT 1
834: FROM JTF_AMV_ITEMS_B
835: WHERE item_id = p_deliverable_id and
836: object_version_number = p_object_version_number;
837:
838: l_exists NUMBER;

Line 1213: FROM JTF_AMV_ITEMS_B

1209:
1210: CURSOR accessname_cur(p_access_name IN VARCHAR2 ) IS
1211: -- SELECT access_name
1212: SELECT 1
1213: FROM JTF_AMV_ITEMS_B
1214: WHERE access_name = p_access_name;
1215:
1216: CURSOR deliverable_accessname_cur(p_item_id IN NUMBER,
1217: p_access_name IN VARCHAR2 ) IS

Line 1220: FROM JTF_AMV_ITEMS_B

1216: CURSOR deliverable_accessname_cur(p_item_id IN NUMBER,
1217: p_access_name IN VARCHAR2 ) IS
1218: -- SELECT access_name
1219: SELECT 1
1220: FROM JTF_AMV_ITEMS_B
1221: WHERE access_name = p_access_name AND item_id <> p_item_id;
1222:
1223: l_dup_access_exception EXCEPTION;
1224:

Line 1546: JTF_AMV_ITEMS_B jtai,

1542: --bug 2665027
1543: CURSOR attachment_cur(p_deliverable_id IN NUMBER,p_file_id IN NUMBER,p_file_name IN VARCHAR2) IS
1544: SELECT jta.attachment_id
1545: FROM JTF_AMV_ATTACHMENTS jta,
1546: JTF_AMV_ITEMS_B jtai,
1547: IBE_DSP_LGL_PHYS_MAP idlpm
1548: WHERE jta.file_name = p_file_name AND
1549: jta.file_id = p_file_id AND
1550: jta.attachment_id = idlpm.attachment_id AND

Line 1557: JTF_AMV_ITEMS_B jtai,

1553:
1554: CURSOR attachment_cur2(p_deliverable_id IN NUMBER,p_file_name IN VARCHAR2) IS
1555: SELECT jta.attachment_id
1556: FROM JTF_AMV_ATTACHMENTS jta,
1557: JTF_AMV_ITEMS_B jtai,
1558: IBE_DSP_LGL_PHYS_MAP idlpm
1559: WHERE jta.file_name = p_file_name AND
1560: jta.file_id is null AND
1561: jta.attachment_id = idlpm.attachment_id AND