APPS.IGC_CBC_GL_FC_PKG dependencies on PO_LOOKUP_CODES

Line 486: FROM po_lookup_codes b, po_bc_distributions pob

482: /* To check if this procedure called for year end */
483:
484: SELECT SUM(INSTR(UPPER(pob.je_line_description), UPPER(b.description)))
485: INTO l_count
486: FROM po_lookup_codes b, po_bc_distributions pob
487: WHERE pob.ae_event_id = l_event_details(i_evt).event_id
488: AND b.lookup_code IN ('IGC YEAR END RESERVE',
489: 'IGC YEAR END UNRESERVE')
490: AND b.lookup_type = 'CONTROL ACTIONS';