DBA Data[Home] [Help]

APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;

88: l_trx_number ra_customer_trx_all.trx_number%TYPE;
89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
93: l_agree_num VARCHAR2(25);
94: TYPE ref_type IS REF CURSOR ;
95: agree_cur ref_type;
96: l_ctr NUMBER;

Line 755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;

751: l_trx_number ra_customer_trx_all.trx_number%TYPE;
752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
756: l_agree_num VARCHAR2(25);
757: l_amount VARCHAR2(50);
758: l_select_mod VARCHAR2(2000);
759: l_exec_ret INTEGER ;

Line 1043: ra_customer_trx_lines_all l

1039: h.start_date_commitment,
1040: h.end_date_commitment,
1041: l.extended_amount
1042: FROM ra_customer_trx_all h,
1043: ra_customer_trx_lines_all l
1044: WHERE h.set_of_books_id = :g_ledger_id
1045: AND h.trx_number = :g_agree_num
1046: AND h.customer_trx_id = l.customer_trx_id';
1047: