DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_RBS_DENORM

Line 888: DELETE FROM pji_rbs_denorm

884: AND plan_version_id > 0;
885:
886: print_time ( ' Number of records in rbs hdr tbl that were deleted is.. = ' || SQL%ROWCOUNT );
887:
888: DELETE FROM pji_rbs_denorm
889: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
890:
891: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
892:

Line 891: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );

887:
888: DELETE FROM pji_rbs_denorm
889: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
890:
891: print_time ( ' Number of rows in pji rbs denorm tbl that were deleted is.. = ' || SQL%ROWCOUNT );
892:
893: DELETE FROM pa_rbs_denorm
894: WHERE struct_version_id = p_rbs_version_id; --Modified for Bug#6884573 by VVJOSHI
895:

Line 6924: , Pji_RBS_DENORM rbs

6920: , fact1.line_type
6921: , g_default_prg_level
6922: ,fact1.PLAN_TYPE_CODE /*4471527 */
6923: FROM pji_fp_aggr_pjp1 fact1
6924: , Pji_RBS_DENORM rbs
6925: , pji_rollup_level_status smart
6926: , pji_pjp_rbs_header rhdr
6927: WHERE 1 = 1
6928: AND fact1.project_id = rhdr.project_id