DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_BUDGET_VERSIONS

Line 11951: From Pa_Budget_Versions bv,

11947: ,0
11948: ,txn.cr_code_combination_id
11949: ,txn.Org_id
11950: ,txn.txn_interface_id --REL12
11951: From Pa_Budget_Versions bv,
11952: Pa_Budget_Types bt,
11953: pa_budgetary_control_options pbct,
11954: pa_transaction_interface_all txn
11955: Where bv.budget_type_code = bt.budget_type_code

Line 12654: From Pa_Budget_Versions bv,

12650: ,DECODE(p_txn_source,'AP DISCOUNTS',NULL,'EXP')
12651: ,DECODE(p_txn_source,'AP DISCOUNTS',NULL,x_Ei_Id)
12652: ,DECODE(p_txn_source,'AP DISCOUNTS',NULL,1)
12653: ,p_txn_interface_id --REL12
12654: From Pa_Budget_Versions bv,
12655: Pa_Budget_Types bt,
12656: pa_budgetary_control_options pbct
12657: Where bt.budget_type_Code = bv.budget_type_Code
12658: and bt.budget_amount_code = 'C'

Line 12850: From Pa_Budget_Versions bv,

12846: ,0
12847: ,txn.cr_code_combination_id
12848: ,txn.Org_id
12849: ,txn.txn_interface_id --REL12
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 13583: From Pa_Budget_Versions bv,

13579: ,'EXP'
13580: ,x_Ei_Id
13581: ,1
13582: ,p_txn_interface_id --REL12
13583: From Pa_Budget_Versions bv,
13584: Pa_Budget_Types bt,
13585: pa_budgetary_control_options pbct
13586: Where bt.budget_type_Code = bv.budget_type_Code
13587: and bt.budget_amount_code = 'C'

Line 13766: From Pa_Budget_Versions bv,

13762: ,0
13763: ,txn.cr_code_combination_id
13764: ,txn.Org_id
13765: ,txn.txn_interface_id --REL12
13766: From Pa_Budget_Versions bv,
13767: Pa_Budget_Types bt,
13768: pa_budgetary_control_options pbct,
13769: pa_transaction_interface_all txn
13770: Where bv.budget_type_code = bt.budget_type_code

Line 14500: From Pa_Budget_Versions bv,

14496: ,'EXP'
14497: ,x_Ei_Id
14498: ,1
14499: ,p_txn_interface_id --REL12
14500: From Pa_Budget_Versions bv,
14501: Pa_Budget_Types bt,
14502: pa_budgetary_control_options pbct
14503: Where bt.budget_type_Code = bv.budget_type_Code
14504: and bt.budget_amount_code = 'C'