DBA Data[Home] [Help]

APPS.CSD_REPAIR_MANAGER_UTIL dependencies on CSI_I_PARTIES

Line 2095: FROM csi_i_parties

2091:
2092: BEGIN
2093: SELECT relationship_type_code
2094: INTO l_relationship
2095: FROM csi_i_parties
2096: WHERE instance_id = l_instance_id
2097: AND party_id = p_sr_rec.sr_party_id
2098: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE - 1) AND NVL(active_end_date,SYSDATE+1)
2099: AND relationship_type_code = NVL(l_crt_inst_party_relation,relationship_type_code)