APPS.CS_KB_WF_PKG dependencies on CS_KB_SETS_B

Line 124: cs_kb_sets_b B,

120: MAX(DECODE(B.STATUS,'NOT',LU2.MEANING,LU1.MEANING))
121: INTO
122: returnValue
123: FROM
124: cs_kb_sets_b B,
125: cs_kb_wf_flow_details D,
126: CS_LOOKUPS LU1,
127: CS_LOOKUPS LU2
128: WHERE

Line 1026: cs_kb_sets_b sets

1022: SELECT DISTINCT details2.GROUP_ID
1023: FROM cs_kb_wf_flow_details details1,
1024: cs_kb_wf_flow_details details2,
1025: cs_kb_wf_flows_b flows,
1026: cs_kb_sets_b sets
1027: WHERE
1028: sets.SET_NUMBER = p_set_number
1029: AND sets.FLOW_DETAILS_ID = details1.FLOW_DETAILS_ID
1030: AND details1.FLOW_ID = flows.FLOW_ID

Line 1576: FROM cs_kb_sets_b

1572: -- set locked by last updater
1573: -- 7117561
1574: SELECT created_by
1575: INTO x_original_author_id
1576: FROM cs_kb_sets_b
1577: WHERE set_id = ( SELECT MAX(set_id) -- Bug fix: 7159784 - made it max(set_id) to get the last updater
1578: FROM cs_kb_sets_b
1579: WHERE set_number = p_set_number
1580: AND status = 'SAV' --Bugfix7228667 - Added the Status to change the Locked by

Line 1578: FROM cs_kb_sets_b

1574: SELECT created_by
1575: INTO x_original_author_id
1576: FROM cs_kb_sets_b
1577: WHERE set_id = ( SELECT MAX(set_id) -- Bug fix: 7159784 - made it max(set_id) to get the last updater
1578: FROM cs_kb_sets_b
1579: WHERE set_number = p_set_number
1580: AND status = 'SAV' --Bugfix7228667 - Added the Status to change the Locked by
1581: ) ;
1582: -- 7117561

Line 1623: FROM cs_kb_sets_b a, fnd_user b

1619: SELECT DISTINCT user_id, user_name
1620: FROM
1621: (
1622: SELECT user_id, user_name
1623: FROM cs_kb_sets_b a, fnd_user b
1624: WHERE set_id IN (
1625: SELECT MIN(set_id)
1626: FROM cs_kb_sets_b
1627: WHERE set_number = p_set_number

Line 1626: FROM cs_kb_sets_b

1622: SELECT user_id, user_name
1623: FROM cs_kb_sets_b a, fnd_user b
1624: WHERE set_id IN (
1625: SELECT MIN(set_id)
1626: FROM cs_kb_sets_b
1627: WHERE set_number = p_set_number
1628: )
1629: AND a.created_by = b.user_id
1630: UNION

Line 1632: FROM cs_kb_sets_b a, fnd_user b

1628: )
1629: AND a.created_by = b.user_id
1630: UNION
1631: SELECT user_id, user_name
1632: FROM cs_kb_sets_b a, fnd_user b
1633: WHERE set_id IN (
1634: SELECT MAX(set_id) --Bug fix:7159784 - made it max(set_id) to get the last updater
1635: FROM cs_kb_sets_b
1636: WHERE set_number = p_set_number AND

Line 1635: FROM cs_kb_sets_b

1631: SELECT user_id, user_name
1632: FROM cs_kb_sets_b a, fnd_user b
1633: WHERE set_id IN (
1634: SELECT MAX(set_id) --Bug fix:7159784 - made it max(set_id) to get the last updater
1635: FROM cs_kb_sets_b
1636: WHERE set_number = p_set_number AND
1637: status = 'SAV' --Bug fix:7228667
1638: )
1639: AND a.created_by = b.user_id