445: l_person_id number;
446:
447: CURSOR c_strategy_level IS
448: SELECT PREFERENCE_VALUE
449: FROM IEX_APP_PREFERENCES_B
450: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
451: and org_id is null
452: and enabled_flag='Y';
453:
806: where resource_id = p_resource_id;
807:
808: CURSOR c_strategy_level IS
809: SELECT PREFERENCE_VALUE
810: FROM IEX_APP_PREFERENCES_B
811: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
812: and org_id is null
813: and enabled_flag='Y';
814:
1201: where resource_id = p_resource_id;
1202:
1203: CURSOR c_strategy_level IS
1204: SELECT PREFERENCE_VALUE
1205: FROM IEX_APP_PREFERENCES_B
1206: WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
1207: and org_id is null
1208: and enabled_flag='Y';
1209: