DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on HZ_PARTIES

Line 2266: FROM HZ_PARTIES

2262:
2263: -- cursor to select the party_name if party is LESSEE
2264: CURSOR get_lessee_info_csr(p_object1_id1 IN VARCHAR2, p_object1_id2 IN VARCHAR2) IS
2265: SELECT party_name,party_number,email_address
2266: FROM HZ_PARTIES
2267: WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));
2268:
2269: l_count NUMBER;
2270: l_dup_flag VARCHAR2(1);