DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_FUNCTIONAL_AREAS

Line 459: select /*+INDEX(PFA PAY_FUNCTIONAL_AREAS_PK)

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,

Line 462: from pay_functional_areas pfa,

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