APPS.PAY_NO_HIGH_RATE_TAX dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 59: from pay_user_column_instances_f

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
59: from pay_user_column_instances_f
60: where user_column_id = l_column_id
61: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
62: AND user_row_id in (select user_row_id from pay_user_rows_f where
63: user_table_id = l_table_id and to_number(l_ptd_amount) between to_number(row_low_range_or_name) and to_number(row_high_range)

Line 72: from pay_user_column_instances_f

68: where USER_ROW_ID = l_row_id
69: AND l_date BETWEEN EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
70: cursor c_get_low_details (l_high_row_id number , l_date date , l_column_id number ) is
71: select VALUE , user_row_id
72: from pay_user_column_instances_f
73: where user_column_id = l_column_id
74: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
75: AND user_row_id <> l_high_row_id;
76: begin

Line 239: from pay_user_column_instances_f

235:
236:
237: cursor c_get_pc_value (l_column_id number , l_date date , l_table_id number , l_ptd_amount varchar2) is
238: select VALUE , user_row_id
239: from pay_user_column_instances_f
240: where user_column_id = l_column_id
241: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
242: AND user_row_id in (select user_row_id
243: from pay_user_rows_f

Line 258: from pay_user_column_instances_f

254:
255:
256: cursor c_get_low_details (l_high_row_id number , l_date date , l_column_id number ) is
257: select VALUE , user_row_id
258: from pay_user_column_instances_f
259: where user_column_id = l_column_id
260: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
261: AND user_row_id <> l_high_row_id;
262:

Line 389: from pay_user_column_instances_f

385:
386: /*
387: cursor c_get_start_value (l_table_id number , l_column_id number , l_ptd_amount varchar2 , l_date date) is
388: select value
389: from pay_user_column_instances_f
390: where user_column_id = l_column_id
391: AND user_row_id in (select user_row_id from pay_user_rows_f
392: where user_table_id = l_table_id AND l_date between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
393: AND to_number(l_ptd_amount) between to_number(ROW_LOW_RANGE_OR_NAME) and to_number(ROW_HIGH_RANGE));

Line 400: from pay_user_column_instances_f

396: /* Modified cursor c_get_start_value to include effective date check */
397:
398: cursor c_get_start_value (l_table_id number , l_column_id number , l_ptd_amount varchar2 , l_date date) is
399: select value
400: from pay_user_column_instances_f
401: where user_column_id = l_column_id
402: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
403: AND user_row_id in (select user_row_id from pay_user_rows_f
404: where user_table_id = l_table_id AND l_date between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 497: from pay_user_column_instances_f

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
497: from pay_user_column_instances_f
498: where user_column_id = l_column_id
499: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
500: AND user_row_id in (select user_row_id from pay_user_rows_f where
501: user_table_id = l_table_id and to_number(l_ptd_amount) between to_number(row_low_range_or_name) and to_number(row_high_range)