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_CONTINUOUS_CALC dependencies on PAY_EVENT_UPDATES

Line 53: from pay_event_updates peu,

49: is
50: select peu.change_type,
51: peu.event_update_id,
52: peu.event_type
53: from pay_event_updates peu,
54: pay_dated_tables pt
55: where ((p_bg_id = peu.business_group_id
56: and peu.legislation_code is null)
57: or (p_leg_code = peu.legislation_code

Line 69: l_event_type pay_event_updates.event_type%type;

65: --
66: cnt number;
67: processed boolean;
68: l_calc_date date;
69: l_event_type pay_event_updates.event_type%type;
70: begin
71: --
72: if (p_calc_date is null) then
73: l_calc_date := p_effective_date;

Line 999: l_mode pay_event_updates.event_type%type;

995: is
996: l_process_event_id number;
997: l_object_version_number number;
998: l_effective_date date;
999: l_mode pay_event_updates.event_type%type;
1000: l_column_name pay_event_updates.column_name%type;
1001: l_old_value date;
1002: l_new_value date;
1003: l_noted_value pay_process_events.noted_value%type;

Line 1000: l_column_name pay_event_updates.column_name%type;

996: l_process_event_id number;
997: l_object_version_number number;
998: l_effective_date date;
999: l_mode pay_event_updates.event_type%type;
1000: l_column_name pay_event_updates.column_name%type;
1001: l_old_value date;
1002: l_new_value date;
1003: l_noted_value pay_process_events.noted_value%type;
1004: lv_processed varchar2(1) := 'N';

Line 11103: l_mode pay_event_updates.event_type%type;

11099: is
11100: l_process_event_id number;
11101: l_object_version_number number;
11102: l_effective_date date;
11103: l_mode pay_event_updates.event_type%type;
11104: l_column_name pay_event_updates.column_name%type;
11105: l_old_value date;
11106: l_new_value date;
11107: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';

Line 11104: l_column_name pay_event_updates.column_name%type;

11100: l_process_event_id number;
11101: l_object_version_number number;
11102: l_effective_date date;
11103: l_mode pay_event_updates.event_type%type;
11104: l_column_name pay_event_updates.column_name%type;
11105: l_old_value date;
11106: l_new_value date;
11107: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';
11108: begin

Line 11685: l_mode pay_event_updates.event_type%type;

11681: is
11682: l_process_event_id number;
11683: l_object_version_number number;
11684: l_effective_date date;
11685: l_mode pay_event_updates.event_type%type;
11686: l_column_name pay_event_updates.column_name%type;
11687: l_old_value date;
11688: l_new_value date;
11689: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';

Line 11686: l_column_name pay_event_updates.column_name%type;

11682: l_process_event_id number;
11683: l_object_version_number number;
11684: l_effective_date date;
11685: l_mode pay_event_updates.event_type%type;
11686: l_column_name pay_event_updates.column_name%type;
11687: l_old_value date;
11688: l_new_value date;
11689: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';
11690: begin

Line 11987: l_mode pay_event_updates.event_type%type;

11983: is
11984: l_process_event_id number;
11985: l_object_version_number number;
11986: l_effective_date date;
11987: l_mode pay_event_updates.event_type%type;
11988: l_column_name pay_event_updates.column_name%type;
11989: l_old_value date;
11990: l_new_value date;
11991: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';

Line 11988: l_column_name pay_event_updates.column_name%type;

11984: l_process_event_id number;
11985: l_object_version_number number;
11986: l_effective_date date;
11987: l_mode pay_event_updates.event_type%type;
11988: l_column_name pay_event_updates.column_name%type;
11989: l_old_value date;
11990: l_new_value date;
11991: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';
11992: begin

Line 12281: l_mode pay_event_updates.event_type%type;

12277: IS
12278: l_process_event_id number;
12279: l_object_version_number number;
12280: l_effective_date date;
12281: l_mode pay_event_updates.event_type%type;
12282: l_column_name pay_event_updates.column_name%type;
12283: l_old_value date;
12284: l_new_value date;
12285: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';

Line 12282: l_column_name pay_event_updates.column_name%type;

12278: l_process_event_id number;
12279: l_object_version_number number;
12280: l_effective_date date;
12281: l_mode pay_event_updates.event_type%type;
12282: l_column_name pay_event_updates.column_name%type;
12283: l_old_value date;
12284: l_new_value date;
12285: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';
12286: BEGIN