DBA Data[Home] [Help]

APPS.PAY_FR_GENERAL dependencies on PAY_USER_TABLES

Line 2864: l_table_id pay_user_tables.user_table_id%type;

2860: p_user_row_id out NOCOPY number,
2861: p_user_column_instance_id out NOCOPY number )
2862: return number is
2863: l_effective_date date;
2864: l_table_id pay_user_tables.user_table_id%type;
2865: l_value pay_user_column_instances_f.value%type;
2866: l_user_column_instance_id pay_user_column_instances_f.user_column_instance_id%type;
2867: l_user_row_id pay_user_column_instances_f.user_row_id%type;
2868: l_proc varchar2(72) := g_package||'.get_table_rate';

Line 2880: , pay_user_tables TAB

2876: CINST.user_row_id
2877: from pay_user_column_instances CINST
2878: , pay_user_columns C
2879: , pay_user_rows R
2880: , pay_user_tables TAB
2881: where TAB.user_table_name = p_table_name
2882: and C.user_table_id = TAB.user_table_id
2883: and nvl (C.business_group_id,
2884: p_bus_group_id) = p_bus_group_id