APPS.PJI_FM_XBS_ACCUM_UTILS dependencies on PJI_XBS_DENORM

Line 1767: from pji_xbs_Denorm

1763: IF p_structure_flag ='N' THEN
1764:
1765: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1766: select sup_project_id,sub_emt_id
1767: from pji_xbs_Denorm
1768: where sup_project_id=p_project_id
1769: and struct_version_id = p_struct_ver_id
1770: and sup_emt_id=p_project_element_id
1771: and sup_level <> sub_level

Line 1776: from pji_xbs_Denorm sup,pji_xbs_Denorm sub

1772: and abs(sup_level - sub_level) <=p_level ;
1773: ELSE
1774: insert into PJI_PLAN_EXTR_TMP(project_id,plan_ver_id)
1775: select sub.sup_project_id,sub.sub_emt_id
1776: from pji_xbs_Denorm sup,pji_xbs_Denorm sub
1777: where sup.sup_project_id=p_project_id
1778: and sup.sup_project_id =sub.sup_project_id
1779: and sup.sup_id = p_struct_ver_id
1780: and sup.sub_id = sub.sup_id

Line 2553: pji_xbs_Denorm wrk

2549: (
2550: SELECT
2551: sub_id,sup_id,sub_rollup_id,sup_emt_id,'WR' record_type
2552: FROM
2553: pji_xbs_Denorm wrk
2554: WHERE
2555: wrk.STRUCT_TYPE = 'PRG' AND
2556: wrk.SUP_ID = l_wk_struct_ver_id_tbl(i) AND
2557: ( wrk.RELATIONSHIP_TYPE <>'LF' OR wrk.RELATIONSHIP_TYPE IS NULL) AND

Line 2563: pji_xbs_Denorm pub

2559: UNION ALL
2560: SELECT
2561: sub_id,sup_id,sub_rollup_id,sup_emt_id,'PR' record_type
2562: FROM
2563: pji_xbs_Denorm pub
2564: WHERE
2565: pub.STRUCT_TYPE = 'PRG' AND
2566: pub.SUP_ID = l_lpb_struct_ver_id_tbl(i) AND
2567: ( pub.RELATIONSHIP_TYPE <>'LF' OR pub.RELATIONSHIP_TYPE IS NULL) AND

Line 2573: pji_xbs_Denorm base

2569: UNION ALL
2570: SELECT
2571: sub_id,sup_id,sub_rollup_id,sup_emt_id,'BR' record_type
2572: FROM
2573: pji_xbs_Denorm base
2574: WHERE
2575: base.STRUCT_TYPE = 'PRG' AND
2576: base.SUP_ID = l_base_struct_ver_id_tbl(i) AND
2577: ( base.RELATIONSHIP_TYPE <>'LF' OR base.RELATIONSHIP_TYPE IS NULL) AND

Line 2582: pji_xbs_Denorm wrk

2578: base.struct_version_id is null
2579: UNION ALL
2580: SELECT sub_id,sup_id,sub_rollup_id,sup_emt_id,'WS' record_type
2581: FROM
2582: pji_xbs_Denorm wrk
2583: WHERE
2584: wrk.STRUCT_TYPE = 'PRG' AND
2585: wrk.SUB_ID = l_wk_struct_ver_id_tbl(i) AND
2586: ( wrk.RELATIONSHIP_TYPE <>'LF' OR wrk.RELATIONSHIP_TYPE IS NULL) AND

Line 2591: pji_xbs_Denorm pub

2587: wrk.struct_version_id is null
2588: UNION ALL
2589: SELECT sub_id,sup_id,sub_rollup_id,sup_emt_id,'PS' record_type
2590: FROM
2591: pji_xbs_Denorm pub
2592: WHERE
2593: pub.STRUCT_TYPE = 'PRG' AND
2594: pub.SUB_ID = l_lpb_struct_ver_id_tbl(i) AND
2595: ( pub.RELATIONSHIP_TYPE <>'LF' OR pub.RELATIONSHIP_TYPE IS NULL) AND

Line 2600: pji_xbs_Denorm base

2596: pub.struct_version_id is null
2597: UNION ALL
2598: SELECT sub_id,sup_id,sub_rollup_id,sup_emt_id,'BS' record_type
2599: FROM
2600: pji_xbs_Denorm base
2601: WHERE
2602: base.STRUCT_TYPE = 'PRG' AND
2603: base.SUB_ID = l_base_struct_ver_id_tbl(i) AND
2604: ( base.RELATIONSHIP_TYPE <>'LF' OR base.RELATIONSHIP_TYPE IS NULL) AND

Line 2647: pji_xbs_Denorm wrk

2643: (
2644: SELECT
2645: wrk.SUB_ID wbs_version_id,'W' record_type
2646: FROM
2647: pji_xbs_Denorm wrk
2648: WHERE
2649: wrk.STRUCT_TYPE = 'PRG' AND
2650: wrk.SUP_ID = l_wk_struct_ver_id_tbl(i) AND
2651: ( wrk.RELATIONSHIP_TYPE <>'LF' OR wrk.RELATIONSHIP_TYPE IS NULL) AND

Line 2657: pji_xbs_Denorm pub

2653: UNION ALL
2654: SELECT
2655: pub.SUB_ID wbs_version_id,'P' record_type
2656: FROM
2657: pji_xbs_Denorm pub
2658: WHERE
2659: pub.STRUCT_TYPE = 'PRG' AND
2660: pub.SUP_ID = l_lpb_struct_ver_id_tbl(i) AND
2661: ( pub.RELATIONSHIP_TYPE <>'LF' OR pub.RELATIONSHIP_TYPE IS NULL) AND

Line 2667: pji_xbs_Denorm base

2663: UNION ALL
2664: SELECT
2665: base.SUB_ID wbs_version_id,'B' record_type
2666: FROM
2667: pji_xbs_Denorm base
2668: WHERE
2669: base.STRUCT_TYPE = 'PRG' AND
2670: base.SUP_ID = l_base_struct_ver_id_tbl(i) AND
2671: ( base.RELATIONSHIP_TYPE <>'LF' OR base.RELATIONSHIP_TYPE IS NULL) AND