552: cursor c_get_profiles is
553: select max(max_score),
554: fnd_profile.value('AS_LEAD_LINK_STATUS'),
555: fnd_profile.value('AS_DEAD_LEAD_STATUS')
556: from as_sales_lead_ranks_b
557: where enabled_flag = 'Y';
558:
559: l_max_score number;
560: l_link_status varchar2(150);
1104: cursor c_get_profiles is
1105: select max(max_score),
1106: fnd_profile.value('AS_LEAD_LINK_STATUS'),
1107: fnd_profile.value('AS_DEAD_LEAD_STATUS')
1108: from as_sales_lead_ranks_b
1109: where enabled_flag = 'Y';
1110:
1111: l_max_score number;
1112: l_link_status varchar2(150);