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 1229: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;

1225: IS
1226:
1227: l_found VARCHAR2(1);
1228: l_instance_exists_flag csi_t_txn_line_details.instance_exists_flag%TYPE;
1229: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;
1230:
1231: CURSOR csi_pty_cur(p_csi_instance_id IN NUMBER) IS
1232: SELECT instance_party_id
1233: FROM csi_i_parties

Line 1273: FROM csi_t_party_details

1269:
1270: BEGIN
1271:
1272: SELECT 'x' INTO l_found
1273: FROM csi_t_party_details
1274: WHERE txn_line_detail_id = p_txn_line_detail_id
1275: AND relationship_type_code = 'OWNER';
1276:
1277: x_return_status := fnd_api.g_ret_sts_error;

Line 1343: FROM csi_t_party_details

1339: ELSIF p_level = 'PARTY_ACCT' THEN
1340:
1341: SELECT txn_line_detail_id
1342: INTO l_txn_line_dtl_id
1343: FROM csi_t_party_details
1344: WHERE txn_party_detail_id = p_level_dtl_id;
1345:
1346: END IF;
1347:

Line 1459: FROM csi_t_party_details

1455: ELSIF p_level = 'PARTY_ACCT' THEN
1456:
1457: SELECT txn_line_detail_id
1458: INTO l_txn_line_dtl_id
1459: FROM csi_t_party_details
1460: WHERE txn_party_detail_id = p_level_dtl_id;
1461:
1462: END IF;
1463:

Line 1481: x_party_detail_rec OUT NOCOPY csi_t_party_details%rowtype,

1477: END get_instance_ref_info;
1478:
1479: PROCEDURE get_party_detail_rec(
1480: p_party_detail_id IN number,
1481: x_party_detail_rec OUT NOCOPY csi_t_party_details%rowtype,
1482: x_return_status OUT NOCOPY varchar2)
1483: IS
1484: BEGIN
1485:

Line 1488: FROM csi_t_party_details

1484: BEGIN
1485:
1486: SELECT *
1487: INTO x_party_detail_rec
1488: FROM csi_t_party_details
1489: WHERE txn_party_detail_id = p_party_detail_id;
1490:
1491: x_return_status := fnd_api.g_ret_sts_success;
1492: