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_EVENT_UPDATES

Line 706: Inserts/Updates the PAY_EVENT_UPDATES table.

702: /*
703: NAME
704: create_event_update
705: NOTES
706: Inserts/Updates the PAY_EVENT_UPDATES table.
707: */
708: procedure create_event_update (p_table_name varchar2,
709: p_column_name varchar2,
710: p_business_group_name varchar2,

Line 727: insert into pay_event_updates

723: else
724: l_business_group_id := null;
725: end if;
726: --
727: insert into pay_event_updates
728: (event_update_id,
729: table_name,
730: column_name,
731: business_group_id,

Line 735: select pay_event_updates_s.nextval,

731: business_group_id,
732: legislation_code,
733: change_type
734: )
735: select pay_event_updates_s.nextval,
736: p_table_name,
737: p_column_name,
738: l_business_group_id,
739: p_legislation_code,

Line 743: from pay_event_updates

739: p_legislation_code,
740: p_change_type
741: from sys.dual
742: where not exists (select ''
743: from pay_event_updates
744: where table_name = p_table_name
745: and column_name = p_column_name
746: and nvl(business_group_id, -999) = nvl(l_business_group_id, -999)
747: and nvl(legislation_code, 'CORE') = nvl(p_legislation_code, 'CORE')