eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DYN_TRIGGERS dependencies on PAY_FUNCTIONAL_TRIGGERS

Line 65: pay_functional_triggers pft,

61: cursor get_trg is
62: select pte.short_name,
63: pte.event_id
64: from pay_functional_areas pfa,
65: pay_functional_triggers pft,
66: pay_trigger_events pte
67: where pte.event_id = pft.event_id
68: and pft.area_id = pfa.area_id
69: and pfa.short_name = p_short_name;

Line 109: pay_functional_triggers pft,

105: is
106: cursor get_trg is
107: select distinct pte.short_name
108: from pay_functional_areas pfa,
109: pay_functional_triggers pft,
110: pay_trigger_events pte
111: where pte.event_id = pft.event_id
112: and pft.area_id = pfa.area_id
113: and pfa.short_name like p_short_name;

Line 655: Inserts/Updates the PAY_FUNCTIONAL_TRIGGERS table.

651: /*
652: NAME
653: create_func_trigger
654: NOTES
655: Inserts/Updates the PAY_FUNCTIONAL_TRIGGERS table.
656: */
657: procedure create_func_trigger (p_area_name varchar2
658: ,p_short_name varchar2
659: ,p_owner varchar2

Line 683: insert into pay_functional_triggers

679: else
680: hr_general2.init_fndload(800,-1);
681: end if;
682:
683: insert into pay_functional_triggers
684: (
685: trigger_id,
686: area_id,
687: event_id

Line 690: pay_functional_triggers_s.nextval,

686: area_id,
687: event_id
688: )
689: select
690: pay_functional_triggers_s.nextval,
691: l_area_id,
692: l_event_id
693: from sys.dual
694: where not exists (select ''

Line 695: from pay_functional_triggers

691: l_area_id,
692: l_event_id
693: from sys.dual
694: where not exists (select ''
695: from pay_functional_triggers
696: where area_id = l_area_id
697: and event_id = l_event_id);
698: --
699: end create_func_trigger;