DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 11953: pa_budgetary_control_options pbct,

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

Line 12656: pa_budgetary_control_options pbct

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

Line 12852: pa_budgetary_control_options pbct,

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

Line 13585: pa_budgetary_control_options pbct

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

Line 13768: pa_budgetary_control_options pbct,

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

Line 14502: pa_budgetary_control_options pbct

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