1865: AND tcl.before_transfer_yn = 'N';
1866:
1867: CURSOR chk_party_csr(p_party_id IN NUMBER) IS
1868: SELECT 'Y' 1869: FROM hz_parties prt 1870: WHERE prt.party_id = p_party_id
1871: AND prt.party_type IN ('PERSON','ORGANIZATION');
1872:
1873: CURSOR chk_cust_acc_csr(p_cust_acc_id IN NUMBER,