APPS.PEFRUSDT dependencies on PAY_USER_TABLES

Line 10: l_range_or_match pay_user_tables.range_or_match%type;

6: p_row_value in varchar2,
7: p_effective_date in date default null)
8: return varchar2 is
9: l_effective_date date;
10: l_range_or_match pay_user_tables.range_or_match%type;
11: l_value pay_user_column_instances_f.value%type;
12: cached boolean := FALSE;
13: g_leg_code varchar2(2);
14: begin

Line 45: from pay_user_tables

41: -- get the type of query to be performed, either range or match
42: --
43: select range_or_match
44: into l_range_or_match
45: from pay_user_tables
46: where upper(user_table_name) = upper(p_table_name)
47: and nvl (business_group_id,
48: p_bus_group_id) = p_bus_group_id;
49: --

Line 57: , pay_user_tables TAB

53: into l_value
54: from pay_user_column_instances_f CINST
55: , pay_user_columns C
56: , pay_user_rows_f R
57: , pay_user_tables TAB
58: where upper(TAB.user_table_name) = upper(p_table_name)
59: and nvl (TAB.business_group_id,
60: p_bus_group_id) = p_bus_group_id
61: and nvl (TAB.legislation_code,

Line 108: , pay_user_tables TAB

104: into l_value
105: from pay_user_column_instances_f CINST
106: , pay_user_columns C
107: , pay_user_rows_f R
108: , pay_user_tables TAB
109: where upper(TAB.user_table_name) = upper(p_table_name)
110: and nvl (TAB.business_group_id,
111: p_bus_group_id) = p_bus_group_id
112: and nvl (TAB.legislation_code,