DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_BUDGET_VERSIONS

Line 12850: From Pa_Budget_Versions bv,

12846: ,txn.cr_code_combination_id
12847: ,txn.Org_id
12848: ,txn.txn_interface_id --REL12
12849: ,txn.vendor_id /*bug 13601768*/
12850: From Pa_Budget_Versions bv,
12851: Pa_Budget_Types bt,
12852: pa_budgetary_control_options pbct,
12853: pa_transaction_interface_all txn
12854: Where bv.budget_type_code = bt.budget_type_code

Line 13579: From Pa_Budget_Versions bv,

13575: ,DECODE(p_txn_source,'AP DISCOUNTS',NULL,x_Ei_Id)
13576: ,DECODE(p_txn_source,'AP DISCOUNTS',NULL,1)
13577: ,p_txn_interface_id --REL12
13578: ,l_vendor_id
13579: From Pa_Budget_Versions bv,
13580: Pa_Budget_Types bt,
13581: pa_budgetary_control_options pbct
13582: Where bt.budget_type_Code = bv.budget_type_Code
13583: and bt.budget_amount_code = 'C'

Line 13778: From Pa_Budget_Versions bv,

13774: ,txn.cr_code_combination_id
13775: ,txn.Org_id
13776: ,txn.txn_interface_id --REL12
13777: ,txn.vendor_id
13778: From Pa_Budget_Versions bv,
13779: Pa_Budget_Types bt,
13780: pa_budgetary_control_options pbct,
13781: pa_transaction_interface_all txn
13782: Where bv.budget_type_code = bt.budget_type_code

Line 14539: From Pa_Budget_Versions bv,

14535: ,x_Ei_Id
14536: ,1
14537: ,p_txn_interface_id --REL12
14538: ,l_vendor_id
14539: From Pa_Budget_Versions bv,
14540: Pa_Budget_Types bt,
14541: pa_budgetary_control_options pbct
14542: Where bt.budget_type_Code = bv.budget_type_Code
14543: and bt.budget_amount_code = 'C'

Line 14725: From Pa_Budget_Versions bv,

14721: ,txn.cr_code_combination_id
14722: ,txn.Org_id
14723: ,txn.txn_interface_id --REL12
14724: ,txn.vendor_id
14725: From Pa_Budget_Versions bv,
14726: Pa_Budget_Types bt,
14727: pa_budgetary_control_options pbct,
14728: pa_transaction_interface_all txn
14729: Where bv.budget_type_code = bt.budget_type_code

Line 15484: From Pa_Budget_Versions bv,

15480: ,x_Ei_Id
15481: ,1
15482: ,p_txn_interface_id --REL12
15483: ,g_vendor_id_tbl(i)
15484: From Pa_Budget_Versions bv,
15485: Pa_Budget_Types bt,
15486: pa_budgetary_control_options pbct
15487: Where bt.budget_type_Code = bv.budget_type_Code
15488: and bt.budget_amount_code = 'C'