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 382: from PAY_USER_COLUMNS

378: and legislation_code = 'NO';
379:
380: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
381: select user_column_id
382: from PAY_USER_COLUMNS
383: where USER_TABLE_ID = l_table_id
384: AND user_column_name = l_freq;
385:
386: /*

Line 492: from PAY_USER_COLUMNS

488: where USER_TABLE_NAME = l_table_name
489: and legislation_code = 'NO';
490: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is
491: select user_column_id
492: from PAY_USER_COLUMNS
493: where USER_TABLE_ID = l_table_id
494: AND user_column_name = l_freq;
495: cursor c_get_tax_value (l_column_id number , l_date date , l_table_id number , l_ptd_amount varchar2) is
496: select VALUE