APPS.PV_BENFT_STATUS_CHANGE dependencies on PV_BENFT_STATUS_MAPS

Line 450: select 'P' from pv_benft_status_maps

446: l_approved_count NUMBER;
447: l_decline_reason_code varchar2(30);
448:
449: cursor lc_access_level (pc_status varchar2, pc_benefit_type varchar2) is
450: select 'P' from pv_benft_status_maps
451: WHERE partner_status_code = pc_status
452: and benefit_type = pc_benefit_type;
453:
454: cursor lc_get_entity_detail (pc_entity_id number) is