DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_RES_TYPES_B

Line 3673: from pa_res_types_b

3669:
3670: for i in 1..l_count loop
3671: select get_res_token(res_type_code,elem_version_id(i))
3672: into level(depth+1)
3673: from pa_res_types_b
3674: where res_type_id = l_res_type_id(i); --bug#3917401 replaced pa_res_types_vl by pa_res_types_b
3675: per_rc_pre := per_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 1); --bug#3793418
3676: equip_rc_pre := equip_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 2); --bug#3793418
3677: mat_rc_pre := mat_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 3); --bug#3793418

Line 3674: where res_type_id = l_res_type_id(i); --bug#3917401 replaced pa_res_types_vl by pa_res_types_b

3670: for i in 1..l_count loop
3671: select get_res_token(res_type_code,elem_version_id(i))
3672: into level(depth+1)
3673: from pa_res_types_b
3674: where res_type_id = l_res_type_id(i); --bug#3917401 replaced pa_res_types_vl by pa_res_types_b
3675: per_rc_pre := per_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 1); --bug#3793418
3676: equip_rc_pre := equip_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 2); --bug#3793418
3677: mat_rc_pre := mat_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 3); --bug#3793418
3678: fin_rc_pre := fin_rc_pre_last + PA_RBS_PREC_PUB.calc_rc_precedence(l_res_type_id(i), 4); --bug#3793418