APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_USER_TABLES

Line 44: from PAY_USER_TABLES

40: l_high_range_tax number;
41: l_total_deduction number;
42: cursor c_get_name(l_table_name VARCHAR2) is
43: select 'Y'
44: from PAY_USER_TABLES
45: where USER_TABLE_NAME = l_table_name
46: and legislation_code = 'NO' ;
47: cursor c_get_table_id(l_table_name VARCHAR2) is
48: select user_table_id

Line 49: from PAY_USER_TABLES

45: where USER_TABLE_NAME = l_table_name
46: and legislation_code = 'NO' ;
47: cursor c_get_table_id(l_table_name VARCHAR2) is
48: select user_table_id
49: from PAY_USER_TABLES
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

Line 218: from PAY_USER_TABLES

214:
215:
216: cursor c_get_name(l_table_name VARCHAR2) is
217: select 'Y'
218: from PAY_USER_TABLES
219: where USER_TABLE_NAME = l_table_name
220: and legislation_code = 'NO' ;
221:
222:

Line 225: from PAY_USER_TABLES

221:
222:
223: cursor c_get_table_id(l_table_name VARCHAR2) is
224: select user_table_id
225: from PAY_USER_TABLES
226: where USER_TABLE_NAME = l_table_name
227: and legislation_code = 'NO';
228:
229:

Line 370: from PAY_USER_TABLES

366: l_column_name varchar2(100);
367:
368: cursor c_get_name(l_table_name VARCHAR2) is
369: select 'Y'
370: from PAY_USER_TABLES
371: where USER_TABLE_NAME = l_table_name
372: and legislation_code = 'NO';
373:
374: cursor c_get_table_id(l_table_name VARCHAR2) is

Line 376: from PAY_USER_TABLES

372: and legislation_code = 'NO';
373:
374: cursor c_get_table_id(l_table_name VARCHAR2) is
375: select user_table_id
376: from PAY_USER_TABLES
377: where USER_TABLE_NAME = l_table_name
378: and legislation_code = 'NO';
379:
380: cursor c_get_column_id (l_freq VARCHAR2 , l_table_id number) is

Line 482: from PAY_USER_TABLES

478: l_normal_tax varchar2(100);
479: l_tax_value varchar2(100);
480: cursor c_get_name(l_table_name VARCHAR2) is
481: select 'Y'
482: from PAY_USER_TABLES
483: where USER_TABLE_NAME = l_table_name
484: and legislation_code = 'NO';
485: cursor c_get_table_id(l_table_name VARCHAR2) is
486: select user_table_id

Line 487: from PAY_USER_TABLES

483: where USER_TABLE_NAME = l_table_name
484: and legislation_code = 'NO';
485: cursor c_get_table_id(l_table_name VARCHAR2) is
486: select user_table_id
487: from PAY_USER_TABLES
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