886: -- Look for waiting period attributes at the appropriate level based on the
887: -- comp object being processed.
888: if p_pgm_id is not null then
889: -- The comp object being passed in is a pgm. Get wtg data at pgm level.
890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
887: -- comp object being processed.
888: if p_pgm_id is not null then
889: -- The comp object being passed in is a pgm. Get wtg data at pgm level.
890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;
909: end if; -- if pgm
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;
909: end if; -- if pgm
910:
909: end if; -- if pgm
910:
911: if p_oipl_id is not null then
912: -- The comp object being evaluated is a OIPL. Get details at OIPL level.
913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
910:
911: if p_oipl_id is not null then
912: -- The comp object being evaluated is a OIPL. Get details at OIPL level.
913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;
932: end if; -- if oipl
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;
932: end if; -- if oipl
933:
936: -- The comp object being evaluated is a plan.
937: if l_envplip_id is not null then
938: -- The plan belongs to a program. Try to get anything defined at the
939: -- plip level first.
940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
937: if l_envplip_id is not null then
938: -- The plan belongs to a program. Try to get anything defined at the
939: -- plip level first.
940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;
959: end if; -- if plip_id is not null
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;
959: end if; -- if plip_id is not null
960: --
960: --
961: -- If nothing was found at the PLIP level above, then search at the PL level
962: --
963: if l_wait_data_found = FALSE and (p_pl_id is not null or p_oipl_id is not null) then
964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
961: -- If nothing was found at the PLIP level above, then search at the PL level
962: --
963: if l_wait_data_found = FALSE and (p_pl_id is not null or p_oipl_id is not null) then
964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;
983: end if; -- wait_data_found=false
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;
983: end if; -- wait_data_found=false
984: end if; -- if plan or oipl(and didn't find oipl level)
987: -- are working with a ptip, look for ptip
988: if l_wait_data_found =FALSE and l_envptip_id is not null and
989: (p_pl_id is not null or p_oipl_id is not null or p_ptip_id is not null
990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
988: if l_wait_data_found =FALSE and l_envptip_id is not null and
989: (p_pl_id is not null or p_oipl_id is not null or p_ptip_id is not null
990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;
1029:
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;
1029:
1030: end if;
1059: if p_pl_id is not null or p_oipl_id is not null then /*Bug 3047147 chk for p_oipl_id also*/
1060: --
1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1060: --
1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.
1070: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.
1070: --
1071: if l_wait_perd_dt_to_use_cd is not null then