DBA Data[Home] [Help]

APPS.IGC_CBC_GL_FC_PKG dependencies on PO_LOOKUP_CODES

Line 475: FROM po_lookup_codes b,xla_ae_lines xal,xla_ae_headers xah

471: /* To check if this procedure called for year end */
472:
473: SELECT SUM(INSTR(UPPER(xal.description), UPPER(b.description)))
474: INTO l_count
475: FROM po_lookup_codes b,xla_ae_lines xal,xla_ae_headers xah
476: WHERE xah.event_id = l_event_details(i_evt).event_id
477: AND xah.ae_header_id = xal.ae_header_id
478: AND b.lookup_code IN ('IGC YEAR END RESERVE',
479: 'IGC YEAR END UNRESERVE')