DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on HZ_PARTIES

Line 2661: FROM HZ_PARTIES

2657:
2658: -- cursor to select the party_name if party is LESSEE
2659: CURSOR get_lessee_info_csr(p_object1_id1 IN VARCHAR2, p_object1_id2 IN VARCHAR2) IS
2660: SELECT party_name,party_number,email_address
2661: FROM HZ_PARTIES
2662: WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));
2663:
2664: --cursor to check the record in interface table for a transaction number
2665: Cursor l_rec_exists_csr (p_transaction_number VARCHAR2) IS