DBA Data[Home] [Help]

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 997: l_mode pay_event_updates.event_type%type;

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

Line 998: l_column_name pay_event_updates.column_name%type;

994: l_process_event_id number;
995: l_object_version_number number;
996: l_effective_date date;
997: l_mode pay_event_updates.event_type%type;
998: l_column_name pay_event_updates.column_name%type;
999: l_old_value date;
1000: l_new_value date;
1001: l_noted_value pay_process_events.noted_value%type;
1002: l_proc varchar2(240) := g_package||'.element_entries_ard';

Line 11071: l_mode pay_event_updates.event_type%type;

11067: is
11068: l_process_event_id number;
11069: l_object_version_number number;
11070: l_effective_date date;
11071: l_mode pay_event_updates.event_type%type;
11072: l_column_name pay_event_updates.column_name%type;
11073: l_old_value date;
11074: l_new_value date;
11075: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';

Line 11072: l_column_name pay_event_updates.column_name%type;

11068: l_process_event_id number;
11069: l_object_version_number number;
11070: l_effective_date date;
11071: l_mode pay_event_updates.event_type%type;
11072: l_column_name pay_event_updates.column_name%type;
11073: l_old_value date;
11074: l_new_value date;
11075: l_proc varchar2(240) := g_package||'.PAY_COST_ALLOCATIONS_F_ard';
11076: begin

Line 11653: l_mode pay_event_updates.event_type%type;

11649: is
11650: l_process_event_id number;
11651: l_object_version_number number;
11652: l_effective_date date;
11653: l_mode pay_event_updates.event_type%type;
11654: l_column_name pay_event_updates.column_name%type;
11655: l_old_value date;
11656: l_new_value date;
11657: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';

Line 11654: l_column_name pay_event_updates.column_name%type;

11650: l_process_event_id number;
11651: l_object_version_number number;
11652: l_effective_date date;
11653: l_mode pay_event_updates.event_type%type;
11654: l_column_name pay_event_updates.column_name%type;
11655: l_old_value date;
11656: l_new_value date;
11657: l_proc varchar2(240) := g_package||'.PAY_USER_COLUMN_INSTANCES_F_ard';
11658: begin

Line 11955: l_mode pay_event_updates.event_type%type;

11951: is
11952: l_process_event_id number;
11953: l_object_version_number number;
11954: l_effective_date date;
11955: l_mode pay_event_updates.event_type%type;
11956: l_column_name pay_event_updates.column_name%type;
11957: l_old_value date;
11958: l_new_value date;
11959: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';

Line 11956: l_column_name pay_event_updates.column_name%type;

11952: l_process_event_id number;
11953: l_object_version_number number;
11954: l_effective_date date;
11955: l_mode pay_event_updates.event_type%type;
11956: l_column_name pay_event_updates.column_name%type;
11957: l_old_value date;
11958: l_new_value date;
11959: l_proc varchar2(240) := g_package||'.FF_GLOBALS_F_ard';
11960: begin

Line 12249: l_mode pay_event_updates.event_type%type;

12245: IS
12246: l_process_event_id number;
12247: l_object_version_number number;
12248: l_effective_date date;
12249: l_mode pay_event_updates.event_type%type;
12250: l_column_name pay_event_updates.column_name%type;
12251: l_old_value date;
12252: l_new_value date;
12253: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';

Line 12250: l_column_name pay_event_updates.column_name%type;

12246: l_process_event_id number;
12247: l_object_version_number number;
12248: l_effective_date date;
12249: l_mode pay_event_updates.event_type%type;
12250: l_column_name pay_event_updates.column_name%type;
12251: l_old_value date;
12252: l_new_value date;
12253: l_proc varchar2(240) := g_package||'.PQH_RATE_MATRIX_RATES_F_ard';
12254: BEGIN