eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_PJP_RBS_HEADER

Line 334: pji_pjp_rbs_header rhd,

330: , 'N'
331: ) lp_flag
332: FROM
333: pji_pjp_proj_batch_map map,
334: pji_pjp_rbs_header rhd,
335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,
338: pa_projects_all ppa,

Line 396: PJI_PJP_RBS_HEADER rhd,

392: , 'N'
393: ) lp_flag
394: FROM
395: PJI_PJP_PROJ_BATCH_MAP map,
396: PJI_PJP_RBS_HEADER rhd,
397: PA_BUDGET_VERSIONS bv,
398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,
400: PA_RBS_PRJ_ASSIGNMENTS rpa,

Line 458: PJI_PJP_RBS_HEADER rhd,

454: , 'N' SECONDARY_RBS_FLAG
455: , 'Y' lp_flag
456: FROM
457: PJI_PJP_PROJ_BATCH_MAP map,
458: PJI_PJP_RBS_HEADER rhd,
459: PA_BUDGET_VERSIONS bv,
460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,
462: PA_RBS_PRJ_ASSIGNMENTS rpa,

Line 905: , pji_pjp_rbs_header rhd

901: FROM
902: pji_pjp_proj_batch_map map
903: , PA_PROJECTS_ALL ppa
904: , pji_pjp_wbs_header whd
905: , pji_pjp_rbs_header rhd
906: WHERE 1=1
907: AND ppa.project_id = map.project_id
908: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'
909: AND map.worker_id = g_worker_id

Line 941: , pji_pjp_rbs_header rhd

937: FROM
938: pji_pjp_proj_batch_map map
939: , PA_PROJECTS_ALL ppa
940: , pji_pjp_wbs_header whd
941: , pji_pjp_rbs_header rhd
942: WHERE 1=1
943: AND ppa.project_id = map.project_id
944: -- AND map.PROJECT_ACTIVE_FLAG = 'Y'
945: AND map.worker_id = g_worker_id

Line 976: DELETE FROM pji_pjp_rbs_header -- Old RBS versions are to be replaced with new ones.

972:
973:
974: IF (p_context = 'RBS') THEN
975:
976: DELETE FROM pji_pjp_rbs_header -- Old RBS versions are to be replaced with new ones.
977: WHERE 1=1
978: AND rbs_version_id in (select rbs_version_id
979: from pa_rbs_versions_b
980: where rbs_header_id = l_rbs_header_id) --Modified for Bug#5728852 by VVJOSHI

Line 3029: FROM pji_pjp_rbs_header rh

3025: AND ev.event_type = 'RBS_ASSOC'
3026: AND bv.project_id = TO_NUMBER(ev.attribute1)
3027: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3028: ( SELECT 1
3029: FROM pji_pjp_rbs_header rh
3030: WHERE rh.project_id = bv.project_id
3031: AND rh.plan_version_id = cbcov.plan_version_id
3032: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3033: )

Line 3104: FROM pji_pjp_rbs_header rh

3100: AND hd1.plan_version_id > 0
3101: -- AND hd2.plan_version_id > 0
3102: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3103: ( SELECT 1
3104: FROM pji_pjp_rbs_header rh
3105: WHERE rh.project_id = bv.project_id
3106: AND rh.plan_version_id = bv.budget_version_id
3107: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3108: )

Line 3180: FROM pji_pjp_rbs_header rh

3176: AND hd1.plan_version_id > 0
3177: -- AND hd2.plan_version_id > 0
3178: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3179: ( SELECT 1
3180: FROM pji_pjp_rbs_header rh
3181: WHERE rh.project_id = bv.project_id
3182: AND rh.plan_version_id = cbcov.plan_version_id
3183: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3184: )

Line 3552: FROM pji_pjp_rbs_header rh

3548: AND ev.event_type = 'RBS_ASSOC'
3549: AND bv.project_id = TO_NUMBER(ev.attribute1)
3550: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3551: ( SELECT 1
3552: FROM pji_pjp_rbs_header rh
3553: WHERE rh.project_id = bv.project_id
3554: AND rh.plan_version_id = cbcov.plan_version_id
3555: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3556: )

Line 3627: FROM pji_pjp_rbs_header rh

3623: AND hd1.plan_version_id > 0
3624: -- AND hd2.plan_version_id > 0
3625: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3626: ( SELECT 1
3627: FROM pji_pjp_rbs_header rh
3628: WHERE rh.project_id = bv.project_id
3629: AND rh.plan_version_id = bv.budget_version_id
3630: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3631: )

Line 3703: FROM pji_pjp_rbs_header rh

3699: AND hd1.plan_version_id > 0
3700: -- AND hd2.plan_version_id > 0
3701: AND NOT EXISTS -- Exclude plan version/RBS version combo for which plan data has already been extracted.
3702: ( SELECT 1
3703: FROM pji_pjp_rbs_header rh
3704: WHERE rh.project_id = bv.project_id
3705: AND rh.plan_version_id = cbcov.plan_version_id
3706: AND rh.rbs_version_id = TO_NUMBER(ev.event_object)
3707: )

Line 8130: , pji_pjp_rbs_header rhdr

8126: ,fact1.PLAN_TYPE_CODE /*4471527 */
8127: FROM pji_fp_aggr_pjp1 fact1
8128: , Pji_RBS_DENORM rbs
8129: , pji_rollup_level_status smart
8130: , pji_pjp_rbs_header rhdr
8131: WHERE 1 = 1
8132: AND fact1.project_id = rhdr.project_id
8133: AND fact1.plan_version_id = rhdr.plan_version_id
8134: AND fact1.plan_type_code = rhdr.plan_type_code /*4471527 */

Line 8406: INSERT INTO pji_pjp_rbs_header

8402:
8403:
8404: print_time ( ' Before update rbs header ' );
8405:
8406: INSERT INTO pji_pjp_rbs_header
8407: (
8408: project_id
8409: , plan_version_id
8410: , rbs_version_id

Line 8437: PJI_PJP_RBS_HEADER head

8433: , bv.plan_type_code
8434: FROM
8435: PJI_FM_EXTR_PLNVER4 bv,
8436: PA_RBS_PRJ_ASSIGNMENTS rpa,
8437: PJI_PJP_RBS_HEADER head
8438: WHERE bv.project_id = rpa.project_id
8439: AND bv.worker_id = g_worker_id
8440: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID
8441: AND bv.PROJECT_ID = head.PROJECT_ID (+)

Line 9613: , pji_pjp_rbs_header rhdr

9609: , pa_resource_asSIGNments ra
9610: , PA_BUDGET_LINES bl
9611: , pa_projects_all ppa
9612: , PJI_ORG_EXTR_INFO oei
9613: , pji_pjp_rbs_header rhdr
9614: , pji_time_cal_period_v prd
9615: , PJI_FM_AGGR_DLY_RATES rates
9616: , pji_fp_txn_accum_header hdr
9617: , pa_rbs_txn_accum_map map

Line 9924: , pji_pjp_rbs_header rhdr

9920: PJI_FM_EXTR_PLNVER4 ver
9921: , pa_resource_asSIGNments ra
9922: , PA_BUDGET_LINES bl
9923: , pa_projects_all ppa
9924: , pji_pjp_rbs_header rhdr
9925: , PJI_FM_AGGR_DLY_RATES rates
9926: , pji_fp_txn_accum_header hdr
9927: , pa_rbs_txn_accum_map map
9928: , PA_PROJ_ELEM_VER_STRUCTURE pevs