DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_DATED_TABLES

Line 17: dated_table_id pay_dated_tables.dated_table_id%TYPE ,

13: index by binary_integer;
14:
15: TYPE t_detailed_output_tab_rec IS RECORD
16: (
17: dated_table_id pay_dated_tables.dated_table_id%TYPE ,
18: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
19: update_type pay_datetracked_events.update_type%TYPE ,
20: surrogate_key pay_process_events.surrogate_key%type ,
21: column_name pay_event_updates.column_name%TYPE ,

Line 820: from pay_dated_tables

816: cursor csr_get_table_id (
817: c_table_name varchar2
818: ) is
819: select dated_table_id
820: from pay_dated_tables
821: where table_name = c_table_name;
822:
823: --
824: --

Line 1005: l_table1 pay_dated_tables.dated_table_id%type;

1001: l_hour_element_entry_id number;
1002: l_new_job_value varchar2 (100);
1003: l_old_job_value varchar2 (100);
1004: l_normal_hours number;
1005: l_table1 pay_dated_tables.dated_table_id%type;
1006: l_table2 pay_dated_tables.dated_table_id%type;
1007: l_table3 pay_dated_tables.dated_table_id%type;
1008: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1009: l_defined_balance_id number;

Line 1006: l_table2 pay_dated_tables.dated_table_id%type;

1002: l_new_job_value varchar2 (100);
1003: l_old_job_value varchar2 (100);
1004: l_normal_hours number;
1005: l_table1 pay_dated_tables.dated_table_id%type;
1006: l_table2 pay_dated_tables.dated_table_id%type;
1007: l_table3 pay_dated_tables.dated_table_id%type;
1008: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1009: l_defined_balance_id number;
1010: l_get_prev_mon_bal_value number;

Line 1007: l_table3 pay_dated_tables.dated_table_id%type;

1003: l_old_job_value varchar2 (100);
1004: l_normal_hours number;
1005: l_table1 pay_dated_tables.dated_table_id%type;
1006: l_table2 pay_dated_tables.dated_table_id%type;
1007: l_table3 pay_dated_tables.dated_table_id%type;
1008: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1009: l_defined_balance_id number;
1010: l_get_prev_mon_bal_value number;
1011: l_get_current_mon_bal_value number;