APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_LOOKUPS

Line 188: /* defined in CSI_LOOKUPS */

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

Line 203: FROM csi_lookups

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

Line 304: /* exists in CSI_LOOKUPS table */

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

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

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

Line 1555: /* defined in CSI_LOOKUPS */

1551:
1552: /*-----------------------------------------------------------*/
1553: /* Procedure name: Is_Update_Status_Exists */
1554: /* Description : Check if the update status is */
1555: /* defined in CSI_LOOKUPS */
1556: /*-----------------------------------------------------------*/
1557:
1558: FUNCTION Is_Update_Status_Exists
1559: (

Line 1570: FROM CSI_LOOKUPS

1566: l_asset_lookup_type VARCHAR2(30) := 'CSI_ASSET_UPDATE_STATUS';
1567:
1568: CURSOR c1 IS
1569: SELECT 'x'
1570: FROM CSI_LOOKUPS
1571: WHERE lookup_code = UPPER(p_update_status)
1572: AND lookup_type = l_asset_lookup_type;
1573: BEGIN
1574: OPEN c1;