DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_TRIGGER_EVENTS

Line 460: INDEX(PTE PAY_TRIGGER_EVENTS_PK)*/

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,
464: pay_trigger_events pte

Line 464: pay_trigger_events pte

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
467: and pft.event_id = pte.event_id
468: and ( pte.generated_flag <> 'Y' or pte.enabled_flag <> 'Y' ) ;