APPS.CN_WKSHT_GET_PUB dependencies on JTF_NOTES_B

Line 190: FROM JTF_NOTES_B WHERE SOURCE_OBJECT_CODE = 'CN_PAYMENT_WORKSHEETS'

186: -- cursor to check if thenote exist
187: CURSOR view_notes_cur (l_payment_worksheet_id cn_worksheet_qg_dtls.payment_worksheet_id%TYPE) IS
188: SELECT 'Y' FROM dual WHERE exists
189: (SELECT 1
190: FROM JTF_NOTES_B WHERE SOURCE_OBJECT_CODE = 'CN_PAYMENT_WORKSHEETS'
191: AND SOURCE_OBJECT_ID = l_payment_worksheet_id
192: );
193:
194: FUNCTION Convert_Amount(l_from_amount NUMBER, l_date Date, c_org_id NUMBER)