APPS.PJI_RESOURCE_UTILZ dependencies on DUAL

Line 86: DUAL;

82: ELSIF (p_calendar_type = 'E') THEN
83: SELECT -1
84: INTO x_calendar_id
85: FROM
86: DUAL;
87: END IF;
88:
89: END GET_PERIOD_DATA;
90:

Line 712: FROM dual;

708:
709: --Get the last summarized date
710: SELECT trunc(to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD'))
711: INTO g_last_summ_date
712: FROM dual;
713:
714: IF g_last_summ_date IS NULL THEN
715: RETURN;
716: END IF;

Line 783: FROM DUAL;

779:
780: --Get corresponding date in the last year
781: SELECT Fii_Time_Api.ent_sd_lysper_end(g_curr_yr_pd_start_date)
782: INTO g_prev_yr_pd_start_date
783: FROM DUAL;
784:
785: --Get the corresponding period in the last year
786: SELECT ent_period_id
787: INTO g_prev_yr_period_id

Line 801: FROM DUAL;

797:
798: --Get corresponding date in the last year
799: SELECT Fii_Time_Api.cal_sd_lysper_end(g_curr_yr_pd_start_date, l_calendar_id)
800: INTO g_prev_yr_pd_start_date
801: FROM DUAL;
802:
803: --Get the corresponding period in the last year
804: SELECT cal_period_id
805: INTO g_prev_yr_period_id

Line 851: FROM DUAL;

847: END IF;
848:
849: SELECT NVL(fnd_profile.value('PA_RES_UTIL_DEF_CALC_METHOD'),'CAPACITY')
850: INTO g_calc_mthd
851: FROM DUAL;
852:
853: --Calculate expected utilization and put it
854: --in the global temporary table
855:

Line 1021: SELECT 1 as tmp_index from dual

1017: sequence
1018: FROM PJI_RES_UTILZ_TMP2
1019: ) r1,
1020: (
1021: SELECT 1 as tmp_index from dual
1022: UNION ALL
1023: SELECT 2 as tmp_index from dual
1024: UNION ALL
1025: SELECT 3 as tmp_index from dual

Line 1023: SELECT 2 as tmp_index from dual

1019: ) r1,
1020: (
1021: SELECT 1 as tmp_index from dual
1022: UNION ALL
1023: SELECT 2 as tmp_index from dual
1024: UNION ALL
1025: SELECT 3 as tmp_index from dual
1026: ) r2
1027: ) r3;

Line 1025: SELECT 3 as tmp_index from dual

1021: SELECT 1 as tmp_index from dual
1022: UNION ALL
1023: SELECT 2 as tmp_index from dual
1024: UNION ALL
1025: SELECT 3 as tmp_index from dual
1026: ) r2
1027: ) r3;
1028:
1029: --Delete records that were inserted initially

Line 1219: FROM dual;

1215:
1216: IF (p_calendar_type = 'G') THEN
1217: SELECT pa_period_process_pkg.application_id
1218: INTO l_application_id
1219: FROM dual;
1220: ELSIF (p_calendar_type = 'P') THEN
1221: SELECT application_id
1222: INTO l_application_id
1223: FROM fnd_application

Line 1377: FROM dual;

1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1374: --Get the site level profile option of the user
1375: SELECT fnd_profile.value('PA_RES_UTIL_DEF_PERIOD_TYPE')
1376: INTO l_pa_res_util_def_pd_types
1377: FROM dual;
1378:
1379: IF (l_pa_res_util_def_pd_types = 'GL') THEN
1380: x_period_type_id := 32;
1381: x_calendar_type := 'G';