DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 12852: pa_budgetary_control_options pbct,

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
12855: and bt.budget_amount_code = 'C'
12856: and bv.current_flag = 'Y'

Line 13581: pa_budgetary_control_options pbct

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'
13584: and bv.project_id = g_project_id_tbl(i)
13585: and bv.current_flag = 'Y'

Line 13780: pa_budgetary_control_options pbct,

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
13783: and bt.budget_amount_code = 'C'
13784: and bv.current_flag = 'Y'

Line 14541: pa_budgetary_control_options pbct

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'
14544: and bv.project_id = g_project_id_tbl(i)
14545: and bv.current_flag = 'Y'

Line 14727: pa_budgetary_control_options pbct,

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
14730: and bt.budget_amount_code = 'C'
14731: and bv.current_flag = 'Y'

Line 15486: pa_budgetary_control_options pbct

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'
15489: and bv.project_id = g_project_id_tbl(i)
15490: and bv.current_flag = 'Y'