DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_USER_COLUMNS

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

3057: else
3058: ln_period_days := least(p_period_days * p_period_number,30.4);
3059: end if; --
3060: if (l_range_or_match <> 'M') then -- matched
3061: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
3062: INDEX(R PAY_USER_ROWS_F_FK1)
3063: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
3064: ORDERED */
3065: CINST.value

Line 3068: , pay_user_columns C

3064: ORDERED */
3065: CINST.value
3066: into l_value
3067: from pay_user_tables TAB
3068: , pay_user_columns C
3069: , pay_user_rows_f R
3070: , pay_user_column_instances_f CINST
3071: where TAB.user_table_id = l_table_id
3072: and C.user_table_id = TAB.user_table_id