455: IS
456:
457: CURSOR c_chk_dyn_triggers_enabled(cp_func_area in VARCHAR2)
458: IS
459: select /*+INDEX(PFA PAY_FUNCTIONAL_AREAS_PK)
460: INDEX(PTE PAY_TRIGGER_EVENTS_PK)*/
461: pte.short_name
462: from pay_functional_areas pfa,
463: pay_functional_triggers pft,
458: IS
459: select /*+INDEX(PFA PAY_FUNCTIONAL_AREAS_PK)
460: INDEX(PTE PAY_TRIGGER_EVENTS_PK)*/
461: pte.short_name
462: from pay_functional_areas pfa,
463: pay_functional_triggers pft,
464: pay_trigger_events pte
465: where pfa.short_name = cp_func_area
466: and pfa.area_id = pft.area_id