[Home] [Help]
73: BEGIN
74:
75: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
76:
77: INSERT INTO PJI_FP_AGGR_PJP1_T
78: (
79: WORKER_ID
80: , PROJECT_ID
81: , PROJECT_ORG_ID
240: , 'ENTR'
241: , g_default_prg_level prg_level
242: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
243: FROM
244: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
245: , pji_time_ENT_PERIOD period
246: , pji_time_ENT_QTR qtr
247: , pji_fm_extr_plnver3_t ver
248: WHERE
296:
297: if l_entyear_id <> -99 then --Bug 10163571 /*For Bug 10305483 */
298:
299: select sum(labor_hrs) into l_laborhrs
300: from PJI_FP_AGGR_PJP1_T
301: where project_id = i.project_id
302: -- and period_type_id = 32 /*For Bug 10305483 */
303: and period_type_id = 128 -- Bug 10305483 - select value for yearly instead of period
304: and calendar_type = 'E'
309: and worker_id = g_worker_id;
310:
311: -- Added for Bug 13365563
312: select sum(labor_hrs) into l_prd_laborhrs
313: from PJI_FP_AGGR_PJP1_T
314: where project_id = i.project_id
315: and period_type_id = 32
316: and calendar_type = 'E'
317: and plan_type_code = i.plan_type_code
327: l_effort_adj_prd := i.quantity - l_prd_laborhrs; --Added for Bug 13365563
328:
329: If (l_effort_adj <> 0) Then
330: select sum(labor_hrs) into l_laborhrs /* For Bug 10305483 */
331: from PJI_FP_AGGR_PJP1_T /* For Bug 10305483 */
332: where project_id = i.project_id
333: and time_id = l_entyear_id /* For Bug 10305483 */
334: /*Added For Bug 10305483 */
335: and project_element_id = i.task_id
335: and project_element_id = i.task_id
336: and RBS_VERSION_ID = i.rbs_struct_version_id
337: and worker_id = g_worker_id;
338:
339: update PJI_FP_AGGR_PJP1_T
340: set labor_hrs = labor_hrs + l_effort_adj
341: where project_id = i.project_id
342: and time_id = l_entyear_id
343: /*Added For Bug 10305483 */
348:
349: --Added for Bug 13365563
350: If (l_effort_adj_prd <> 0) Then
351: select sum(labor_hrs) into l_prd_laborhrs
352: from PJI_FP_AGGR_PJP1_T
353: where project_id = i.project_id
354: and time_id = l_entperiod_id
355: and project_element_id = i.task_id
356: and RBS_VERSION_ID = i.rbs_struct_version_id
356: and RBS_VERSION_ID = i.rbs_struct_version_id
357: and worker_id = g_worker_id;
358:
359:
360: update PJI_FP_AGGR_PJP1_T
361: set labor_hrs = labor_hrs + l_effort_adj_prd
362: where project_id = i.project_id
363: and time_id = l_entperiod_id
364: and project_element_id = i.task_id
397: BEGIN
398:
399: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
400:
401: INSERT INTO pji_fp_aggr_pjp1_t
402: (
403: WORKER_ID
404: , PROJECT_ID
405: , PROJECT_ORG_ID
568: , l_line_type line_type
569: , g_default_prg_level prg_level
570: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
571: FROM
572: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
573: , pji_time_CAL_PERIOD period
574: , pji_time_CAL_QTR qtr
575: , pji_fm_extr_plnver3_t ver
576: WHERE
635: BEGIN
636:
637: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
638:
639: INSERT INTO pji_fp_aggr_pjp1_t
640: (
641: WORKER_ID
642: , PROJECT_ID
643: , PROJECT_ORG_ID
813: , l_line_type
814: , g_default_prg_level prg_level
815: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
816: FROM
817: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
818: , pji_time_CAL_PERIOD period
819: , pji_time_CAL_QTR qtr
820: , pji_fm_extr_plnver3_t ver
821: WHERE
885: if (pji_utils.get_setup_parameter('TIME_PHASE_FLAG') = 'Y' )
886: and (l_calendar_type is null) then
887: select min(calendar_type)
888: into l_calendar_type
889: from pji_fp_aggr_pjp1_t
890: where worker_id = g_worker_id;
891:
892: elsif l_calendar_type is null then
893: l_calendar_type := 'G';
919: null;
920: end ;
921: IF l_time_phase_change = 0 THEN
922:
923: INSERT INTO PJI_FP_AGGR_PJP1_T
924: (
925: WORKER_ID
926: , PROJECT_ID
927: , PROJECT_ORG_ID
1088: ,l_line_type
1089: , g_default_prg_level prg_level
1090: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1091: FROM
1092: PJI_FP_AGGR_PJP1_T fact1
1093: , pji_time_CAL_PERIOD period
1094: , pji_time_CAL_QTR qtr
1095: , pji_fm_extr_plnver3_t ver
1096: WHERE
1134: ELSE
1135: /* 4604617 */
1136: /*When Time phase change from PA/GL to None then update the existing A lines
1137: When Gl to PA or vice versa , insert only one -A lines */
1138: MERGE INTO PJI_FP_AGGR_PJP1_T F1
1139: USING ( SELECT g_worker_id WORKER_ID
1140: , fact1.PROJECT_ID
1141: , fact1.PROJECT_ORG_ID
1142: , fact1.PROJECT_ORGANIZATION_ID
1210: , g_default_prg_level PRG_LEVEL
1211: , l_line_type LINE_TYPE
1212: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1213: FROM
1214: PJI_FP_AGGR_PJP1_T fact1
1215: , pji_time_CAL_PERIOD period
1216: , pji_time_CAL_QTR qtr
1217: , pji_fm_extr_plnver3_t ver
1218: WHERE
1498: BEGIN
1499:
1500: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1501:
1502: INSERT INTO pji_fp_aggr_pjp1_t
1503: (
1504: WORKER_ID
1505: , PRG_LEVEL
1506: , PROJECT_ID
1652: , SUM(CUSTOM15) CUSTOM15
1653: , l_line_type
1654: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1655: FROM
1656: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1657: , pji_fm_extr_plnver3_t ver
1658: WHERE
1659: fact1.calendar_type = l_calendar_type
1660: AND fact1.period_type_id = l_period_type_id
1721: BEGIN
1722:
1723: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1724:
1725: INSERT INTO pji_fp_aggr_pjp1_t
1726: (
1727: WORKER_ID
1728: , PROJECT_ID
1729: , PROJECT_ORG_ID
1904: , 'PAR'
1905: , g_default_prg_level prg_level
1906: , fact1.plan_type_code plan_type_code /* 4471527 */
1907: FROM
1908: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1909: , pji_time_CAL_PERIOD period
1910: , pji_time_CAL_QTR qtr
1911: , pji_fm_extr_plnver3_t ver
1912: WHERE
1964: BEGIN
1965:
1966: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
1967:
1968: INSERT INTO pji_fp_aggr_pjp1_t
1969: (
1970: WORKER_ID
1971: , PROJECT_ID
1972: , PROJECT_ORG_ID
2147: , 'GLR'
2148: , g_default_prg_level prg_level
2149: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2150: FROM
2151: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2152: , pji_time_CAL_PERIOD period
2153: , pji_time_CAL_QTR qtr
2154: , pji_fm_extr_plnver3_t ver
2155: WHERE
2207: BEGIN
2208:
2209: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2210:
2211: INSERT INTO pji_fp_aggr_pjp1_t
2212: (
2213: WORKER_ID
2214: , PROJECT_ID
2215: , PROJECT_ORG_ID
2390: , 'ENTR'
2391: , g_default_prg_level prg_level
2392: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2393: FROM
2394: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2395: , pji_time_ENT_PERIOD period
2396: , pji_time_ENT_QTR qtr
2397: , pji_fm_extr_plnver3_t ver
2398: WHERE
3194:
3195: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
3196:
3197: /* Commented for bug 4005006
3198: INSERT INTO pji_fp_aggr_pjp1_t
3199: (
3200: WORKER_ID
3201: , PROJECT_ID
3202: , PROJECT_ORG_ID
4290: , 'CF' line_type
4291: , fact.time_dangling_flag time_dangling_flag
4292: , fact.rate_dangling_flag rate_dangling_flag
4293: , g_default_prg_level prg_level
4294: FROM pji_fp_aggr_pjp1_t fact
4295: , pji_time_cal_period non_pa_cal
4296: , pji_time_ent_period pa_cal
4297: , pji_fm_extr_plnver3_t ver
4298: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4336: , a.TIME_DANGLING_FLAG
4337: , a.RATE_DANGLING_FLAG;
4338: End of 4005006*/
4339:
4340: INSERT INTO pji_fp_aggr_pjp1_t
4341: (
4342: WORKER_ID
4343: , PROJECT_ID
4344: , PROJECT_ORG_ID
4570: , (LEAST(non_pa_cal.end_date,pa_cal.end_date) -
4571: Greatest(non_pa_cal.start_date,pa_cal.start_date)+1)
4572: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4573: , fact.plan_type_code plan_type_code /* 4471527 */
4574: FROM pji_fp_aggr_pjp1_t fact
4575: , pji_time_cal_period_v non_pa_cal
4576: , pji_time_ent_period_v pa_cal
4577: , pji_fm_extr_plnver3_t ver
4578: , (SELECT currency_code,
4632: BEGIN
4633:
4634: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
4635:
4636: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries in FP Reporting lines.
4637: (
4638: WORKER_ID
4639: , PROJECT_ID
4640: , PROJECT_ORG_ID
5781:
5782: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
5783:
5784: /* Commented for bug 4005006
5785: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
5786: (
5787: WORKER_ID
5788: , PROJECT_ID
5789: , PROJECT_ORG_ID
6877: , 'CN' line_type
6878: , fact.time_dangling_flag time_dangling_flag
6879: , fact.rate_dangling_flag rate_dangling_flag
6880: , g_default_prg_level prg_level
6881: FROM pji_fp_aggr_pjp1_t fact
6882: , pji_time_ent_period pa_cal
6883: , pji_fm_extr_plnver3_t ver
6884: WHERE 1=1
6885: AND fact.CALENDAR_TYPE = 'A'
6930: , a.TIME_DANGLING_FLAG
6931: , a.RATE_DANGLING_FLAG;
6932: End of 4005006*/
6933:
6934: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries in pjp1 table.
6935: (
6936: WORKER_ID
6937: , PROJECT_ID
6938: , PROJECT_ORG_ID
7162: , cur.mau mau
7163: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7164: / (fact.end_date - fact.start_date+1) factor
7165: , fact.plan_type_code plan_type_code /* 4471527 */
7166: FROM pji_fp_aggr_pjp1_t fact
7167: , pji_time_ent_period_v entCal
7168: , pji_fm_extr_plnver3_t ver
7169: , (SELECT currency_code,
7170: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7226:
7227: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7228:
7229: /* Commented for bug 4005006
7230: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7231: (
7232: WORKER_ID
7233: , PROJECT_ID
7234: , PROJECT_ORG_ID
7384: , 'CF' line_type
7385: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7386: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7387: , g_default_prg_level prg_level
7388: FROM pji_fp_aggr_pjp1_t fact
7389: , pji_time_cal_period non_pa_cal
7390: -- , pji_org_extr_info orginfo
7391: , pji_time_ent_period pa_cal
7392: , pji_fm_extr_plnver3_t ver
7424: , fact.TIME_DANGLING_FLAG
7425: , fact.RATE_DANGLING_FLAG;
7426: End of bug 4005006*/
7427:
7428: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7429: (
7430: WORKER_ID
7431: , PROJECT_ID
7432: , PROJECT_ORG_ID
7578: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7579: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7580: , g_default_prg_level prg_level
7581: , fact.plan_type_code plan_type_code /* 4471527 */
7582: FROM pji_fp_aggr_pjp1_t fact
7583: , pji_time_cal_period_v non_pa_cal
7584: , pji_time_ent_period_v pa_cal
7585: , pji_fm_extr_plnver3_t ver
7586: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7633: BEGIN
7634:
7635: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7636:
7637: INSERT INTO pji_fp_aggr_pjp1_t -- PA, GL calendar entries.
7638: (
7639: WORKER_ID
7640: , PROJECT_ID
7641: , PROJECT_ORG_ID
7838: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
7839:
7840: /* Commented for bug 4005006
7841:
7842: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
7843: (
7844: WORKER_ID
7845: , PROJECT_ID
7846: , PROJECT_ORG_ID
7994: , 'CN' line_type
7995: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
7996: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7997: , g_default_prg_level prg_level
7998: FROM pji_fp_aggr_pjp1_t fact
7999: , pji_time_ent_period pa_cal
8000: , pji_fm_extr_plnver3_t ver
8001: WHERE fact.CALENDAR_TYPE = 'A'
8002: AND fact.worker_id = g_worker_id
8046: , fact.RATE_DANGLING_FLAG;
8047:
8048: End of bug 4005006*/
8049:
8050: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries.
8051: (
8052: WORKER_ID
8053: , PROJECT_ID
8054: , PROJECT_ORG_ID
8200: , fact.TIME_DANGLING_FLAG TIME_DANGLING_FLAG
8201: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8202: , g_default_prg_level prg_level
8203: , fact.plan_type_code plan_type_code /* 4471527 */
8204: FROM pji_fp_aggr_pjp1_t fact
8205: , pji_time_ent_period_v pa_cal
8206: , pji_fm_extr_plnver3_t ver
8207: WHERE fact.CALENDAR_TYPE = 'A'
8208: AND fact.worker_id = g_worker_id
8258:
8259: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
8260:
8261: /* Commented for bug 4005006
8262: INSERT INTO pji_fp_aggr_pjp1_t
8263: (
8264: worker_id
8265: , PROJECT_ID
8266: , PROJECT_ORG_ID
9353: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
9354: , 'CF' line_type
9355: , fact.time_dangling_flag time_dangling_flag
9356: , fact.rate_dangling_flag rate_dangling_flag
9357: FROM pji_fp_aggr_pjp1_t fact
9358: , pji_time_cal_period non_pa_cal
9359: , pji_org_extr_info orginfo
9360: , pji_time_cal_period pa_cal
9361: , pji_fm_extr_plnver3_t ver
9403: , a.TIME_DANGLING_FLAG
9404: , a.RATE_DANGLING_FLAG;
9405: End for 4005006*/
9406:
9407: INSERT INTO pji_fp_aggr_pjp1_t
9408: (
9409: worker_id
9410: , PROJECT_ID
9411: , PROJECT_ORG_ID
9634: , ROUND (nvl(fact.custom15,0)*calDet.factor/cur.mau)*cur.mau custom15
9635: , fact.time_dangling_flag time_dangling_flag
9636: , fact.rate_dangling_flag rate_dangling_flag
9637: , fact.plan_type_code plan_type_code /* 4471527 */
9638: FROM pji_fp_aggr_pjp1_t fact,
9639: (SELECT /*+ NO_MERGE */ (LEAST(pri.end_date,sec.end_date) - Greatest(pri.start_date,sec.start_date)+1)
9640: / (pri.end_date - pri.start_date+1) factor,
9641: ppa.project_id,
9642: ver.rbs_struct_Version_id rbs_struct_version_id,
9722: BEGIN
9723:
9724: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
9725:
9726: INSERT INTO pji_fp_aggr_pjp1_t
9727: (
9728: worker_id
9729: , PROJECT_ID
9730: , PROJECT_ORG_ID
10883:
10884: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
10885:
10886: /* Commented for bug 4005006
10887: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
10888: (
10889: worker_id
10890: , PROJECT_ID
10891: , PROJECT_ORG_ID
11977: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
11978: , 'CF' line_type
11979: , NULL time_dangling_flag
11980: , NULL rate_dangling_flag
11981: FROM pji_fp_aggr_pjp1_t fact
11982: , pji_org_extr_info orginfo
11983: , pji_time_cal_period pa_cal
11984: , pji_fm_extr_plnver3_t ver
11985: WHERE 1=1
12036: , a.RATE_DANGLING_FLAG;
12037:
12038: End for 4005006 */
12039:
12040: INSERT INTO pji_fp_aggr_pjp1_t -- Non time phased entries..
12041: (
12042: worker_id
12043: , PROJECT_ID
12044: , PROJECT_ORG_ID
12268: , cur.mau mau
12269: , (LEAST(fact.end_date,pa_cal.end_date) - Greatest(fact.start_date,pa_cal.start_date)+1)
12270: / (fact.end_date - fact.start_date+1) factor
12271: , fact.plan_type_code plan_type_code /* 4471527 */
12272: FROM pji_fp_aggr_pjp1_t fact
12273: , pji_org_extr_info orginfo
12274: , pji_time_cal_period_v pa_cal
12275: , pji_fm_extr_plnver3_t ver
12276: ,(SELECT currency_code,
12339:
12340: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12341:
12342: /* Commented for bug 4005006
12343: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12344: (
12345: worker_id
12346: , PROJECT_ID
12347: , PROJECT_ORG_ID
12497: , 'CF' line_type
12498: , NULL TIME_DANGLING_FLAG
12499: , NULL RATE_DANGLING_FLAG
12500: , g_default_prg_level prg_level
12501: FROM pji_fp_aggr_pjp1_t fact
12502: , pji_time_cal_period non_pa_cal
12503: , pji_org_extr_info orginfo
12504: , pji_time_cal_period pa_cal
12505: , pji_fm_extr_plnver3_t ver
12538: , fact.PLAN_TYPE_ID ;
12539:
12540: End of bug 4005006*/
12541:
12542: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12543: (
12544: worker_id
12545: , PROJECT_ID
12546: , PROJECT_ORG_ID
12692: , NULL TIME_DANGLING_FLAG
12693: , NULL RATE_DANGLING_FLAG
12694: , g_default_prg_level prg_level
12695: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODe /* 4471527 */
12696: FROM pji_fp_aggr_pjp1_t fact
12697: , pji_time_cal_period_v non_pa_cal
12698: , pji_org_extr_info orginfo
12699: , pji_time_cal_period_v pa_cal
12700: , pji_fm_extr_plnver3_t ver
12747: BEGIN
12748:
12749: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12750:
12751: INSERT INTO pji_fp_aggr_pjp1_t -- For PA/GL entries.
12752: (
12753: worker_id
12754: , PROJECT_ID
12755: , PROJECT_ORG_ID
12966: END IF;
12967:
12968: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
12969: /* Commented for bug 4005006
12970: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
12971: (
12972: worker_id
12973: , PROJECT_ID
12974: , PROJECT_ORG_ID
13125: , 'CN' line_type
13126: , NULL TIME_DANGLING_FLAG
13127: , NULL RATE_DANGLING_FLAG
13128: , g_default_prg_level prg_level
13129: FROM pji_fp_aggr_pjp1_t fact
13130: , pji_org_extr_info orginfo
13131: , pji_time_cal_period pa_cal
13132: , pji_fm_extr_plnver3_t ver
13133: WHERE 1=1
13183: orginfo.pa_calendar_id,
13184: orginfo.gl_calendar_id;
13185: End of bug 4005006*/
13186:
13187: INSERT INTO pji_fp_aggr_pjp1_t -- For non time phased entries.
13188: (
13189: worker_id
13190: , PROJECT_ID
13191: , PROJECT_ORG_ID
13337: , NULL TIME_DANGLING_FLAG
13338: , NULL RATE_DANGLING_FLAG
13339: , g_default_prg_level prg_level
13340: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13341: FROM pji_fp_aggr_pjp1_t fact
13342: , pji_org_extr_info orginfo
13343: , pji_time_cal_period_v pa_cal
13344: , pji_fm_extr_plnver3_t ver
13345: WHERE 1=1