50: where USER_TABLE_NAME = l_table_name
51: and legislation_code = 'NO';
52: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
53: select user_column_id
54: from PAY_USER_COLUMNS
55: where USER_TABLE_ID = l_table_id
56: AND user_column_name = l_freq;
57: cursor c_get_pc_value (l_column_id number , l_date date , l_table_id number , l_ptd_amount varchar2) is
58: select VALUE , user_row_id
228:
229:
230: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
231: select user_column_id
232: from PAY_USER_COLUMNS
233: where USER_TABLE_ID = l_table_id
234: AND user_column_name = l_freq;
235:
236:
377: and legislation_code = 'NO';
378:
379: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
380: select user_column_id
381: from PAY_USER_COLUMNS
382: where USER_TABLE_ID = l_table_id
383: AND user_column_name = l_freq;
384:
385: /*
486: where USER_TABLE_NAME = l_table_name
487: and legislation_code = 'NO';
488: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
489: select user_column_id
490: from PAY_USER_COLUMNS
491: where USER_TABLE_ID = l_table_id
492: AND user_column_name = l_freq;
493: cursor c_get_tax_value (l_column_id number , l_date date , l_table_id number , l_ptd_amount varchar2) is
494: select VALUE