APPS.IBC_ASSOCIATIONS_GRP dependencies on IBC_ASSOCIATION_TYPES_B

Line 606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;

602: CURSOR cur_assoc IS
603: SELECT A.COLUMN_VALUE association_type_code
604: FROM TABLE(CAST(p_assoc_type_codes AS JTF_VARCHAR2_TABLE_100)) A
605: MINUS
606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;
607:
608: BEGIN
609: -- ******************* Standard Begins *******************
610: -- Standard Start of API savepoint

Line 1447: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t

1443: CURSOR Get_Assoc IS
1444: SELECT a.ASSOCIATION_TYPE_CODE, a.ASSOCIATED_OBJECT_VAL1, a.ASSOCIATED_OBJECT_VAL2,
1445: a.ASSOCIATED_OBJECT_VAL3, a.ASSOCIATED_OBJECT_VAL4, a.ASSOCIATED_OBJECT_VAL5,
1446: t.CALL_BACK_PKG
1447: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t
1448: WHERE a.CONTENT_ITEM_ID = p_content_item_id AND
1449: ((a.citem_version_id IS NULL AND p_citem_version_id IS NULL)
1450: OR
1451: (a.citem_version_id = p_citem_version_id)) AND

Line 1456: FROM IBC_ASSOCIATION_TYPES_B

1452: a.ASSOCIATION_TYPE_CODE = t.ASSOCIATION_TYPE_CODE;
1453:
1454: CURSOR Get_CallBack IS
1455: SELECT CALL_BACK_PKG
1456: FROM IBC_ASSOCIATION_TYPES_B
1457: WHERE ASSOCIATION_TYPE_CODE = l_assoc_type_code;
1458:
1459: BEGIN
1460: -- ******************* Standard Begins *******************

Line 1696: FROM ibc_association_types_b

1692: post_plsql_block VARCHAR2(200) := '.Get_Object_Name(:at, :v1, :v2, :v3, :v4, :v5, :xn, :xc, :xret, :xmc, :md); END;';
1693:
1694: CURSOR c_callback(p_assoc_type_code VARCHAR2) IS
1695: SELECT call_back_pkg
1696: FROM ibc_association_types_b
1697: WHERE association_type_code = p_assoc_type_code;
1698:
1699: BEGIN
1700: