[Home] [Help]
3783: if (p_rbs_header_id is not null) then
3784:
3785: select max(ver.RBS_VERSION_ID)
3786: into l_rbs_version_id
3787: from PA_RBS_VERSIONS_B ver,
3788: PJI_PJP_RBS_HEADER rbs_hdr
3789: where ver.RBS_HEADER_ID = p_rbs_header_id and
3790: ver.STATUS_CODE = 'FROZEN' and
3791: ver.RBS_VERSION_ID = rbs_hdr.RBS_VERSION_ID;