DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 3022: l_value pay_user_column_instances_f.value%type;

3018: return varchar2 is
3019: l_effective_date date;
3020: l_range_or_match pay_user_tables.range_or_match%type;
3021: l_table_id pay_user_tables.user_table_id%type;
3022: l_value pay_user_column_instances_f.value%type;
3023: ln_period_days number;
3024: begin
3025: hr_utility_trace('p_bus_group_id: ' ||p_bus_group_id);
3026: hr_utility_trace('p_table_name: ' ||p_table_name);

Line 3070: , pay_user_column_instances_f CINST

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
3073: and nvl (C.business_group_id,
3074: p_bus_group_id) = p_bus_group_id