[Home] [Help]
90: where sre_id = (select id
91: from okc_subclass_roles
92: where scs_code = 'PROGRAM' and rle_code = 'OKL_VENDOR')
93: and srd_id = ( select id
94: from okc_subclass_rg_defs
95: where scs_code = 'PROGRAM' and rgd_code = 'LAVENB');
96:
97: -- Get Article ID and Release
98: l_sae_id NUMBER := NULL;