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 369: from PAY_USER_TABLES

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

Line 375: from PAY_USER_TABLES

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

Line 480: from PAY_USER_TABLES

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

Line 485: from PAY_USER_TABLES

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