APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_II_RELATIONSHIPS

Line 1375: FROM csi_t_ii_relationships

1371: l_upd_ns_inst varchar2(1) := 'Y';
1372:
1373: CURSOR comp_of_cur(p_tl_id IN number, p_tld_id IN number) IS
1374: SELECT txn_relationship_id
1375: FROM csi_t_ii_relationships
1376: WHERE transaction_line_id = p_tl_id
1377: AND (subject_id = p_tld_id
1378: OR
1379: object_id = p_tld_id)

Line 1387: FROM csi_t_ii_relationships iir,

1383:
1384: CURSOR other_nsrc_cur(p_tl_id IN number, p_tld_id IN number) IS
1385: SELECT sub_tld.instance_id sub_instance_id,
1386: obj_tld.instance_id obj_instance_id
1387: FROM csi_t_ii_relationships iir,
1388: csi_t_txn_line_details sub_tld,
1389: csi_t_txn_line_details obj_tld
1390: WHERE iir.transaction_line_id = p_tl_id
1391: AND (iir.subject_id = p_tld_id

Line 2585: --Create these relations in csi_t_ii_relationships table

2581: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2582: raise fnd_api.g_exc_error;
2583: END IF;
2584:
2585: --Create these relations in csi_t_ii_relationships table
2586:
2587: IF l_temp_txn_ii_rltns_tbl.count > 0 THEN
2588: csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls(
2589: p_api_version => 1.0,