APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_USER_COLUMNS

Line 2818: , pay_user_columns C

2814:
2815: CURSOR csr_get_table_value(p_table_id NUMBER, p_proration_fac NUMBER, p_col_name VARCHAR2, p_row_value NUMBER) IS
2816: SELECT fnd_number.canonical_to_number(CINST.value)* fnd_number.canonical_to_number(p_proration_fac)
2817: FROM pay_user_tables TAB
2818: , pay_user_columns C
2819: , pay_user_rows_f R
2820: , pay_user_column_instances_f CINST
2821: WHERE TAB.user_table_id = p_table_id
2822: AND C.user_table_id = TAB.user_table_id

Line 4333: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)

4329: p_table_name in varchar2)
4330: return varchar2 is
4331:
4332: CURSOR csr_get_pro_table_val IS
4333: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
4334: INDEX(R PAY_USER_ROWS_F_FK1)
4335: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
4336: ORDERED */
4337: round((fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * p_period_days,2),

Line 4341: , pay_user_columns C

4337: round((fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * p_period_days,2),
4338: round((fnd_number.canonical_to_number (R.row_high_range)/30.4) * p_period_days,2),
4339: CINST.value
4340: from pay_user_tables TAB
4341: , pay_user_columns C
4342: , pay_user_rows_f R
4343: , pay_user_column_instances_f CINST
4344: where TAB.user_table_id = p_table_id
4345: and C.user_table_id = TAB.user_table_id

Line 4537: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)

4533:
4534: /*Bug 14094610 - End*/
4535:
4536: elsif (l_range_or_match <> 'M') then -- matched
4537: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
4538: INDEX(R PAY_USER_ROWS_F_FK1)
4539: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
4540: ORDERED */
4541: CINST.value

Line 4544: , pay_user_columns C

4540: ORDERED */
4541: CINST.value
4542: into l_value
4543: from pay_user_tables TAB
4544: , pay_user_columns C
4545: , pay_user_rows_f R
4546: , pay_user_column_instances_f CINST
4547: where TAB.user_table_id = l_table_id
4548: and C.user_table_id = TAB.user_table_id