DBA Data[Home] [Help]

APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_USER_COLUMNS

Line 54: from PAY_USER_COLUMNS

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

Line 232: from PAY_USER_COLUMNS

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:

Line 381: from PAY_USER_COLUMNS

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: /*

Line 490: from PAY_USER_COLUMNS

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