APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TRX_LINES

Line 610: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;

606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
609: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;
610: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;
611: l_start_date FUN_PERIOD_STATUSES.START_DATE%TYPE;
612: l_end_date FUN_PERIOD_STATUSES.END_DATE%TYPE;
613: sqlstmt VARCHAR2(3000);
614:

Line 992: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;

988: LOOP
989: l_header_trx_id := 0;
990: l_line_id := 0;
991: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
992: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
993:
994: INSERT INTO FUN_TRX_HEADERS
995: (TRX_ID,
996: BATCH_ID,

Line 1257: INSERT INTO FUN_TRX_LINES

1253: END LOOP;
1254: CLOSE c_trx_attm;
1255:
1256:
1257: INSERT INTO FUN_TRX_LINES
1258: (LINE_ID,
1259: TRX_ID,
1260: CREATED_BY,
1261: CREATION_DATE,

Line 1286: FROM FUN_TRX_LINES

1282: INIT_AMOUNT_DR,
1283: RECI_AMOUNT_CR,
1284: RECI_AMOUNT_DR,
1285: DESCRIPTION
1286: FROM FUN_TRX_LINES
1287: WHERE TRX_ID = l_trx_id.TRX_ID;
1288:
1289: INSERT INTO FUN_DIST_LINES
1290: (TRX_ID,