DBA Data[Home] [Help]

APPS.AR_TRX_GLOBAL_PROCESS_TMP dependencies on AR_TRX_SALESCREDITS_TMP_GT

Line 614: INSERT INTO ar_trx_salescredits_tmp_gt

610: IF RecExist >= 1
611: THEN
612: FOR i IN p_trx_salescredits_tbl.FIRST .. p_trx_salescredits_tbl.LAST
613: LOOP
614: INSERT INTO ar_trx_salescredits_tmp_gt
615: ( TRX_SALESCREDIT_ID,
616: TRX_LINE_ID,
617: SALESREP_ID,
618: SALESREP_NUMBER,

Line 719: from ar_trx_salescredits_tmp_gt

715: and TRX_LINE_ID is NULL;
716:
717: cursor sc_cur (P_TRX_HEADER_ID number, P_TRX_LINE_ID number) is
718: select *
719: from ar_trx_salescredits_tmp_gt
720: where --(TRX_HEADER_ID = P_TRX_HEADER_ID) or
721: (TRX_LINE_ID = P_TRX_LINE_ID);
722: i number :=0;
723: j number :=0;