APPS.PA_INVOICE_XFER dependencies on PA_DRAFT_INVOICES

Line 881: pa_draft_invoices ORG_DI

877: ORG_DI.PROJFUNC_INVTRANS_RATE_TYPE exchg_type,
878: ORG_DI.INV_CURRENCY_CODE inv_curr_code,
879: INT_LINE.CONVERSION_RATE exchg_rate
880: FROM ra_interface_lines INT_LINE,
881: pa_draft_invoices ORG_DI
882: WHERE INT_LINE.interface_line_attribute1||'' = P_Project_Num
883: AND ORG_DI.request_id = P_Request_Id
884: AND ltrim(rtrim(INT_LINE.interface_line_attribute2))
885: = ltrim(rtrim(to_char(ORG_DI.Draft_invoice_num)))

Line 909: pa_draft_invoices CM_DI,

905: CM_DI.PROJFUNC_INVTRANS_RATE_TYPE exchg_type,
906: CM_DI.INV_CURRENCY_CODE inv_curr_code,
907: INT_LINE.CONVERSION_RATE exchg_rate
908: FROM ra_interface_lines INT_LINE,
909: pa_draft_invoices CM_DI,
910: pa_draft_invoices ORG_DI,
911: ra_customer_trx TRX,
912: ra_batch_sources SOURCE
913: WHERE INT_LINE.interface_line_attribute1 = P_Project_Num

Line 910: pa_draft_invoices ORG_DI,

906: CM_DI.INV_CURRENCY_CODE inv_curr_code,
907: INT_LINE.CONVERSION_RATE exchg_rate
908: FROM ra_interface_lines INT_LINE,
909: pa_draft_invoices CM_DI,
910: pa_draft_invoices ORG_DI,
911: ra_customer_trx TRX,
912: ra_batch_sources SOURCE
913: WHERE INT_LINE.interface_line_attribute1 = P_Project_Num
914: AND CM_DI.request_id = P_Request_Id

Line 928: CM_CAN_FLAG PA_DRAFT_INVOICES.CANCELED_FLAG%TYPE;

924: AND INT_LINE.TRX_NUMBER = CM_DI.RA_INVOICE_NUMBER
925: AND INT_LINE.BATCH_SOURCE_NAME = P_Batch_Src; /* 2366742 */
926:
927:
928: CM_CAN_FLAG PA_DRAFT_INVOICES.CANCELED_FLAG%TYPE;
929: PA_ORIG_INV_AMT NUMBER;
930: PA_CM_INV_AMT NUMBER;
931: AR_ORIG_INV_AMT NUMBER;
932: CM_INV_CONV_AMT NUMBER;

Line 937: PA_EXCHG_TYPE PA_DRAFT_INVOICES.INV_RATE_TYPE%TYPE;/* bug 2142736*/

933: PA_CM_INTERFACE_AMT RA_INTERFACE_LINES.AMOUNT%TYPE;
934: ROUND_OFF_AMT NUMBER;
935: L_MAX_LINE RA_INTERFACE_LINES.INTERFACE_LINE_ATTRIBUTE6%TYPE;
936: l_rate NUMBER;
937: PA_EXCHG_TYPE PA_DRAFT_INVOICES.INV_RATE_TYPE%TYPE;/* bug 2142736*/
938:
939:
940: BEGIN
941: FOR cur_get_inv_info IN get_invoice_info

Line 1095: Update PA_DRAFT_INVOICES

1091: End if;
1092:
1093: /*Changed cur_get_inv_info.exchg_type to PA_EXCHG_TYPE*/
1094:
1095: Update PA_DRAFT_INVOICES
1096: set ACCTD_CURR_CODE = P_Proj_Func_Cur,
1097: ACCTD_RATE_TYPE = decode(cur_get_inv_info.inv_curr_code,
1098: P_Proj_Func_Cur,NULL,PA_EXCHG_TYPE),
1099: ACCTD_RATE_DATE = decode(cur_get_inv_info.inv_curr_code,