APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_II_RELATIONSHIPS

Line 1432: FROM csi_t_ii_relationships

1428: l_upd_ns_inst varchar2(1) := 'Y';
1429:
1430: CURSOR comp_of_cur(p_tl_id IN number, p_tld_id IN number) IS
1431: SELECT txn_relationship_id
1432: FROM csi_t_ii_relationships
1433: WHERE transaction_line_id = p_tl_id
1434: AND (subject_id = p_tld_id
1435: OR
1436: object_id = p_tld_id)

Line 1444: FROM csi_t_ii_relationships iir,

1440:
1441: CURSOR other_nsrc_cur(p_tl_id IN number, p_tld_id IN number) IS
1442: SELECT sub_tld.instance_id sub_instance_id,
1443: obj_tld.instance_id obj_instance_id
1444: FROM csi_t_ii_relationships iir,
1445: csi_t_txn_line_details sub_tld,
1446: csi_t_txn_line_details obj_tld
1447: WHERE iir.transaction_line_id = p_tl_id
1448: AND (iir.subject_id = p_tld_id

Line 2644: --Create these relations in csi_t_ii_relationships table

2640: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2641: raise fnd_api.g_exc_error;
2642: END IF;
2643:
2644: --Create these relations in csi_t_ii_relationships table
2645:
2646: IF l_temp_txn_ii_rltns_tbl.count > 0 THEN
2647: csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls(
2648: p_api_version => 1.0,