APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_LOOKUPS

Line 186: /* defined in CSI_LOOKUPS */

182:
183: /*-----------------------------------------------------------*/
184: /* Procedure name: Is_Pty_Source_tab_Valid */
185: /* Description : Check if the Party Source Table is */
186: /* defined in CSI_LOOKUPS */
187: /*-----------------------------------------------------------*/
188:
189: FUNCTION Is_Pty_Source_tab_Valid
190: (

Line 201: FROM csi_lookups

197: l_pty_lookup_type VARCHAR2(30) := 'CSI_PARTY_SOURCE_TABLE';
198:
199: CURSOR c1 IS
200: SELECT 'x'
201: FROM csi_lookups
202: WHERE lookup_code = UPPER(p_party_source_table)
203: AND lookup_type = l_pty_lookup_type;
204: BEGIN
205: OPEN c1;

Line 302: /* exists in CSI_LOOKUPS table */

298:
299: /*-----------------------------------------------------------*/
300: /* Procedure name: Is_Party_Rel_type_code_Valid */
301: /* Description : Check if the Party relationship type code */
302: /* exists in CSI_LOOKUPS table */
303: /*-----------------------------------------------------------*/
304:
305: FUNCTION Is_Pty_Rel_type_Valid
306: ( p_party_rel_type_code IN VARCHAR2,

Line 1113: /* type code exists in CSI_LOOKUPS */

1109:
1110: /*-----------------------------------------------------------*/
1111: /* Procedure name: Is_Acct_Rel_type_Valid */
1112: /* Description : Check if the Party account relationship */
1113: /* type code exists in CSI_LOOKUPS */
1114: /*-----------------------------------------------------------*/
1115:
1116: FUNCTION Is_Acct_Rel_type_Valid
1117: ( p_acct_rel_type_code IN VARCHAR2,

Line 1551: /* defined in CSI_LOOKUPS */

1547:
1548: /*-----------------------------------------------------------*/
1549: /* Procedure name: Is_Update_Status_Exists */
1550: /* Description : Check if the update status is */
1551: /* defined in CSI_LOOKUPS */
1552: /*-----------------------------------------------------------*/
1553:
1554: FUNCTION Is_Update_Status_Exists
1555: (

Line 1566: FROM CSI_LOOKUPS

1562: l_asset_lookup_type VARCHAR2(30) := 'CSI_ASSET_UPDATE_STATUS';
1563:
1564: CURSOR c1 IS
1565: SELECT 'x'
1566: FROM CSI_LOOKUPS
1567: WHERE lookup_code = UPPER(p_update_status)
1568: AND lookup_type = l_asset_lookup_type;
1569: BEGIN
1570: OPEN c1;