APPS.PN_CREATE_ACC dependencies on PN_ACCOUNTING_EVENTS_ALL

Line 1393: FROM PN_ACCOUNTING_EVENTS_ALL

1389: END LOOP;
1390:
1391: SELECT nvl(max(event_number),0) + 1
1392: INTO l_event_number
1393: FROM PN_ACCOUNTING_EVENTS_ALL
1394: WHERE source_table = 'PN_PAYMENT_TERMS'
1395: AND SOURCE_ID = v_pn_payment_term_id
1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:

Line 1400: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

1396: AND EVENT_TYPE_CODE = v_pn_event_type_code;
1397:
1398: pnp_debug_pkg.log('Before event insert');
1399:
1400: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
1401: (
1402: ACCOUNTING_EVENT_ID ,
1403: EVENT_TYPE_CODE ,
1404: ACCOUNTING_DATE ,

Line 2147: FROM pn_accounting_events_all

2143: END LOOP;
2144:
2145: SELECT nvl(max(event_number),0) + 1
2146: INTO l_event_number
2147: FROM pn_accounting_events_all
2148: WHERE source_table = 'PN_PAYMENT_TERMS'
2149: AND SOURCE_ID = v_pn_payment_term_id
2150: AND EVENT_TYPE_CODE = v_pn_event_type_code;
2151:

Line 2157: INSERT INTO PN_ACCOUNTING_EVENTS_ALL

2153:
2154:
2155: l_context := 'Inserting into PN_ACCOUNTING_EVENTS';
2156:
2157: INSERT INTO PN_ACCOUNTING_EVENTS_ALL
2158: (
2159: ACCOUNTING_EVENT_ID ,
2160: EVENT_TYPE_CODE ,
2161: ACCOUNTING_DATE ,