APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_PARTY_DETAILS

Line 210: FROM csi_t_party_details

206: BEGIN
207:
208: SELECT 'X'
209: INTO l_found
210: FROM csi_t_party_details
211: WHERE txn_party_detail_id = p_txn_party_detail_id;
212:
213: x_return_status := fnd_api.g_ret_sts_success;
214:

Line 1256: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;

1252: IS
1253:
1254: l_found VARCHAR2(1);
1255: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1256: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;
1257:
1258: CURSOR csi_pty_cur(p_csi_instance_id IN NUMBER) IS
1259: SELECT instance_party_id
1260: FROM csi_i_parties

Line 1300: FROM csi_t_party_details

1296:
1297: BEGIN
1298:
1299: SELECT 'x' INTO l_found
1300: FROM csi_t_party_details
1301: WHERE txn_line_detail_id = p_txn_line_detail_id
1302: AND relationship_type_code = 'OWNER';
1303:
1304: x_return_status := fnd_api.g_ret_sts_error;

Line 1370: FROM csi_t_party_details

1366: ELSIF p_level = 'PARTY_ACCT' THEN
1367:
1368: SELECT txn_line_detail_id
1369: INTO l_txn_line_dtl_id
1370: FROM csi_t_party_details
1371: WHERE txn_party_detail_id = p_level_dtl_id;
1372:
1373: END IF;
1374:

Line 1486: FROM csi_t_party_details

1482: ELSIF p_level = 'PARTY_ACCT' THEN
1483:
1484: SELECT txn_line_detail_id
1485: INTO l_txn_line_dtl_id
1486: FROM csi_t_party_details
1487: WHERE txn_party_detail_id = p_level_dtl_id;
1488:
1489: END IF;
1490:

Line 1508: x_party_detail_rec OUT NOCOPY csi_t_party_details%rowtype,

1504: END get_instance_ref_info;
1505:
1506: PROCEDURE get_party_detail_rec(
1507: p_party_detail_id IN number,
1508: x_party_detail_rec OUT NOCOPY csi_t_party_details%rowtype,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: BEGIN
1512:

Line 1515: FROM csi_t_party_details

1511: BEGIN
1512:
1513: SELECT *
1514: INTO x_party_detail_rec
1515: FROM csi_t_party_details
1516: WHERE txn_party_detail_id = p_party_detail_id;
1517:
1518: x_return_status := fnd_api.g_ret_sts_success;
1519: