APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on DUAL

Line 329: SELECT p_starting_organization_id FROM DUAL;

325: AND se.org_structure_version_id = l_org_structure_version_id
326: START WITH se.organization_id_parent = p_starting_organization_id
327: AND se.org_structure_version_id = l_org_structure_version_id
328: UNION
329: SELECT p_starting_organization_id FROM DUAL;
330: */
331:
332: CURSOR specific_org_only is
333: SELECT hou.organization_id

Line 783: FROM sys.dual;

779: -- hr_utility.trace(to_char(l_stage));
780:
781: SELECT substr(l_org_fcst_period_type,1,1)
782: INTO l_time_phased_code
783: FROM sys.dual;
784:
785: l_stage := 400;
786: pa_debug.g_err_stage := l_stage||': Get Plan Type Id';
787: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1008: FROM sys.dual;

1004: SELECT '-'||decode(substr(to_char(l_org_id),1,1),'-',
1005: substr(to_char(l_org_id),2),to_char(l_org_id))||
1006: '-'||to_char(l_business_group_id)
1007: INTO l_bg_org
1008: FROM sys.dual;
1009:
1010: l_stage := 1800;
1011: -- hr_utility.trace(to_char(l_stage));
1012:

Line 1018: FROM DUAL;

1014: SELECT substrb(l_org_name,1,(30 - lengthb(l_bg_org)))||l_bg_org
1015: ,substrb(l_org_name,1,(25 - lengthb(l_bg_org)))||l_bg_org
1016: INTO l_project_name
1017: ,l_project_number
1018: FROM DUAL;
1019:
1020: -- hr_utility.trace(to_char(l_stage));
1021: pa_debug.g_err_stage := l_stage||': Project Name is '||l_project_name;
1022: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2248: FROM dual;

2244: -- hr_utility.trace(to_char(l_stage));
2245:
2246: SELECT pa_org_fcst_elements_s.NEXTVAL
2247: INTO l_fe_new_seq
2248: FROM dual;
2249:
2250: l_stage := 5900;
2251: -- hr_utility.trace(to_char(l_stage));
2252: l_fe_forecast_element_id_tab(l_fe_ctr) := l_fe_new_seq;

Line 2291: FROM DUAL;

2287: l_stage := 6300;
2288: -- hr_utility.trace(to_char(l_stage));
2289: SELECT pa_org_forecast_lines_s.NEXTVAL
2290: INTO l_fl_new_seq
2291: FROM DUAL;
2292:
2293: l_stage := 6400;
2294: -- hr_utility.trace(to_char(l_stage));
2295:

Line 2369: FROM DUAL;

2365: -- hr_utility.trace(to_char(l_stage));
2366: l_fl_ctr := nvl(l_fl_forecast_line_id_tab.last+1,1);
2367: SELECT pa_org_forecast_lines_s.NEXTVAL
2368: INTO l_fl_new_seq
2369: FROM DUAL;
2370: l_stage := 6700;
2371: -- hr_utility.trace(to_char(l_stage));
2372:
2373: l_fl_forecast_line_id_tab(l_fl_ctr) := l_fl_new_seq;

Line 2723: FROM DUAL;

2719: (l_fl_revenue_tab(j)+
2720: l_fl_borrowed_revenue_tab(j)+
2721: l_fl_tp_rev_in_tab(j)-
2722: l_fl_tp_rev_out_tab(j)) * 100)
2723: FROM DUAL;
2724:
2725: l_stage := 7800;
2726: -- hr_utility.trace(to_char(l_stage));
2727: l_records_affected := SQL%ROWCOUNT;

Line 3413: FROM DUAL;

3409: (l_bl_revenue_tab(i)+
3410: l_bl_borrowed_revenue_tab(i)+
3411: l_bl_tp_revenue_in_tab(i)-
3412: l_bl_tp_revenue_out_tab(i)) * 100)
3413: FROM DUAL;
3414:
3415: l_stage := 9700;
3416: -- hr_utility.trace(to_char(l_stage));
3417: l_records_affected := SQL%ROWCOUNT;

Line 3898: FROM DUAL;

3894: (l_bl_revenue_tab(i)+
3895: l_bl_borrowed_revenue_tab(i)+
3896: l_bl_tp_revenue_in_tab(i)-
3897: l_bl_tp_revenue_out_tab(i)) * 100)
3898: FROM DUAL;
3899:
3900: l_stage := 11200;
3901: -- hr_utility.trace(to_char(l_stage));
3902: