DBA Data[Home] [Help]

APPS.IGC_CBC_FUNDS_CHECKER dependencies on IGC_CC_HEADERS

Line 1234: FROM igc_cc_headers

1230: ) IS
1231:
1232: CURSOR c_igc_head IS
1233: SELECT cc_state
1234: FROM igc_cc_headers
1235: WHERE cc_header_id = g_cc_header_id;
1236:
1237: l_doc_type VARCHAR2(100);
1238: l_cc_state VARCHAR2(2);

Line 1268: FROM igc_cc_headers_all

1264: IF (l_reference_8 IS NULL) THEN
1265: /*Added for CBC Upgrade - End*/
1266: IF (p_org_id IS NULL) THEN
1267: SELECT org_id INTO p_org_id
1268: FROM igc_cc_headers_all
1269: WHERE cc_header_id = g_cc_header_id;
1270: IF (g_debug_mode = 'Y') THEN
1271: Put_Debug_Msg (l_full_path, 'Org ID: '|| p_org_id || ' obtained from igc_cc_headers_all');
1272: END IF;

Line 1271: Put_Debug_Msg (l_full_path, 'Org ID: '|| p_org_id || ' obtained from igc_cc_headers_all');

1267: SELECT org_id INTO p_org_id
1268: FROM igc_cc_headers_all
1269: WHERE cc_header_id = g_cc_header_id;
1270: IF (g_debug_mode = 'Y') THEN
1271: Put_Debug_Msg (l_full_path, 'Org ID: '|| p_org_id || ' obtained from igc_cc_headers_all');
1272: END IF;
1273: END IF;
1274: x_entity_type := 'CC_CONTRACTS';
1275: IF l_cc_state = 'PR' THEN

Line 1422: FROM igc_cc_headers_all igch,

1418: CURSOR c_del_events is
1419: SELECT
1420: eve.event_id, xle.valuation_method, xle.ledger_id, igch.cc_num,
1421: igch.org_id
1422: FROM igc_cc_headers_all igch,
1423: xla_transaction_entities xle,
1424: xla_events eve
1425: WHERE xle.source_id_int_1 = igch.cc_header_id
1426: AND xle.entity_id = eve.entity_id