APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on DUAL

Line 328: SELECT p_starting_organization_id FROM DUAL;

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

Line 782: FROM sys.dual;

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

Line 1007: FROM sys.dual;

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

Line 1017: FROM DUAL;

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

Line 2247: FROM dual;

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

Line 2290: FROM DUAL;

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

Line 2368: FROM DUAL;

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

Line 2722: FROM DUAL;

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

Line 3412: FROM DUAL;

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

Line 3897: FROM DUAL;

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