DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on DUAL

Line 141: SELECT 1 FROM DUAL

137: AND bv.budget_type_code IS NOT NULL
138: AND DECODE(c_budget_types,'ALL','Y',bt.upgrade_budget_type_flag) = 'Y'
139: AND NVL(bt.plan_type,'BUDGET') = 'BUDGET' /* Bug 2758786 */
140: AND EXISTS (
141: SELECT 1 FROM DUAL
142: WHERE c_budget_statuses = 'ALL'
143: UNION ALL
144: SELECT 1 FROM DUAL
145: WHERE (current_original_flag = 'Y' OR

Line 144: SELECT 1 FROM DUAL

140: AND EXISTS (
141: SELECT 1 FROM DUAL
142: WHERE c_budget_statuses = 'ALL'
143: UNION ALL
144: SELECT 1 FROM DUAL
145: WHERE (current_original_flag = 'Y' OR
146: original_flag = 'Y' OR
147: current_flag = 'Y' OR
148: budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING) )