APPS.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_PENDING_APPROVALS_V

Line 1281: FROM ibc_pending_approvals_v

1277: l_api_version CONSTANT NUMBER := 1.0;
1278: l_dummy VARCHAR2(2);
1279: CURSOR c_chk_notification IS
1280: SELECT 'X'
1281: FROM ibc_pending_approvals_v
1282: WHERE item_key = p_item_key;
1283: BEGIN
1284: -- ******* Standard Begins ********
1285:

Line 1541: FROM IBC_PENDING_APPROVALS_V

1537: -- for current user and which item key has the format followed by
1538: -- Submit_For_Approval proc.
1539: CURSOR c_notifications IS
1540: SELECT *
1541: FROM IBC_PENDING_APPROVALS_V
1542: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
1543:
1544: --******** local variable for standards **********
1545: l_api_name CONSTANT VARCHAR2(30) := 'Get_Pending_Approvals';

Line 2693: FROM ibc_pending_approvals_v pav2

2689: IAS.ITEM_TYPE = 'IBC_WF'
2690: AND IAS.ACTIVITY_STATUS = 'NOTIFIED'
2691: AND IAS.ASSIGNED_USER = U.ROLE_NAME
2692: AND NOT EXISTS(SELECT 'X'
2693: FROM ibc_pending_approvals_v pav2
2694: WHERE pav2.item_key = IAS.item_key
2695: AND p_user_pattern NOT LIKE '%[' || U.user_name || ']%'
2696: )
2697: GROUP BY IAS.ITEM_KEY;