DBA Data[Home] [Help]

APPS.PA_CC_ENC_IMPORT_FCK dependencies on DUAL

Line 42: FROM DUAL

38:
39: /* Modified the sql into exist clause to improve performance */
40: select 'Y'
41: into l_budget_control_flag
42: FROM DUAL
43: WHERE EXISTS ( select null
44: from pa_budgetary_control_options pbct
45: ,pa_budget_types bv
46: where pbct.project_id = p_project_id

Line 340: FROM DUAL

336: ,l_fc_rec_tab(i).LAST_UPDATED_BY
337: ,l_fc_rec_tab(i).CREATED_BY
338: ,l_fc_rec_tab(i).CREATION_DATE
339: ,l_fc_rec_tab(i).LAST_UPDATE_LOGIN
340: FROM DUAL
341: WHERE l_fc_rec_tab(i).status_code <> 'Z' ;
342:
343: print_msg('No rec inserted ['||sql%rowcount);
344: