DBA Data[Home] [Help]

APPS.FV_WF_BE_APPROVAL dependencies on FV_BE_TRANSACTION_TYPES

Line 39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,

35: e_invalid EXCEPTION;
36:
37: TYPE be_trx_record IS RECORD (
38: gl_date Fv_Be_Trx_Dtls.gl_date%TYPE,
39: trx_type Fv_Be_Transaction_Types.apprn_transaction_type%TYPE,
40: trx_code Fv_Be_Trx_Dtls.sub_type%TYPE,
41: inc_dec_flag VARCHAR2(15),
42: amount Fv_Be_Trx_Dtls.amount%TYPE,
43: fund_dist Fv_Be_Trx_Dtls.budgeting_segments%TYPE );

Line 1109: FROM Fv_Be_Trx_Dtls D, Fv_Be_Transaction_Types T

1105: D.sub_type ,
1106: decode(D.increase_decrease_flag,'I','Increase','Decrease') ,
1107: D.amount ,
1108: D.budgeting_segments
1109: FROM Fv_Be_Trx_Dtls D, Fv_Be_Transaction_Types T
1110: WHERE D.set_of_books_id = vg_sob_id
1111: AND D.doc_id = vg_doc_id
1112: AND D.transaction_type_id = T.be_tt_id
1113: AND D.revision_num = (SELECT MAX(revision_num)