DBA Data[Home] [Help]

APPS.IGC_CBC_GL_FC_PKG dependencies on XLA_AE_LINES

Line 63: ,xla_ae_lines xal

59: ,pck.event_id EVENT_ID
60: ,xah.last_update_date LAST_UPDATE_DATE
61: ,xah.creation_date CREATION_DATE
62: FROM xla_ae_headers xah
63: ,xla_ae_lines xal
64: ,xla_transaction_entities xte
65: ,gl_bc_packets pck
66: WHERE xah.ae_header_id = pck.ae_header_id
67: AND xal.ae_header_id = pck.ae_header_id

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')