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 388: from pay_user_column_instances_f

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

Line 399: from pay_user_column_instances_f

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

Line 495: from pay_user_column_instances_f

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
495: from pay_user_column_instances_f
496: where user_column_id = l_column_id
497: AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
498: AND user_row_id in (select user_row_id from pay_user_rows_f where
499: 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)