1844: AND tcl.before_transfer_yn = 'N';
1845:
1846: CURSOR chk_party_csr(p_party_id IN NUMBER) IS
1847: SELECT 'Y' 1848: FROM hz_parties prt 1849: WHERE prt.party_id = p_party_id
1850: AND prt.party_type IN ('PERSON','ORGANIZATION');
1851:
1852: CURSOR chk_cust_acc_csr(p_cust_acc_id IN NUMBER,