DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on CSI_I_PARTIES

Line 1642: FROM csi_i_parties

1638:
1639: BEGIN
1640: SELECT relationship_type_code
1641: INTO l_relationship
1642: FROM csi_i_parties
1643: WHERE instance_id = x_instance_id
1644: AND party_id = p_party_id
1645: AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE - 1) AND NVL(active_end_date,SYSDATE+1)
1646: AND relationship_type_code = NVL(l_crt_inst_party_relation,relationship_type_code)