APPS.HRUSERDT dependencies on PAY_USER_TABLES

Line 38: l_range_or_match pay_user_tables.range_or_match%type;

34: p_row_value in varchar2,
35: p_effective_date in date default null)
36: return varchar2 is
37: l_effective_date date;
38: l_range_or_match pay_user_tables.range_or_match%type;
39: l_table_id pay_user_tables.user_table_id%type;
40: l_value pay_user_column_instances_f.value%type;
41: begin
42: --

Line 39: l_table_id pay_user_tables.user_table_id%type;

35: p_effective_date in date default null)
36: return varchar2 is
37: l_effective_date date;
38: l_range_or_match pay_user_tables.range_or_match%type;
39: l_table_id pay_user_tables.user_table_id%type;
40: l_value pay_user_column_instances_f.value%type;
41: begin
42: --
43: -- Use either the supplied date, or the date from fnd_sessions

Line 76: from pay_user_tables

72: -- get the type of query to be performed, either range or match
73: --
74: select range_or_match, user_table_id
75: into l_range_or_match, l_table_id
76: from pay_user_tables
77: where upper(user_table_name) = upper(p_table_name)
78: and nvl (business_group_id,
79: p_bus_group_id) = p_bus_group_id
80: and nvl(legislation_code, g_leg_code) = g_leg_code;

Line 90: from pay_user_tables TAB

86: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
87: ORDERED */
88: CINST.value
89: into l_value
90: from pay_user_tables TAB
91: , pay_user_columns C
92: , pay_user_rows_f R
93: , pay_user_column_instances_f CINST
94: where TAB.user_table_id = l_table_id

Line 137: from pay_user_tables TAB

133: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
134: ORDERED */
135: CINST.value
136: into l_value
137: from pay_user_tables TAB
138: , pay_user_columns C
139: , pay_user_rows_f R
140: , pay_user_column_instances_f CINST
141: where TAB.user_table_id = l_table_id

Line 190: from pay_user_tables TAB

186: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
187: ORDERED */
188: CINST.value
189: into l_value
190: from pay_user_tables TAB
191: , pay_user_columns C
192: , pay_user_rows_f R
193: , pay_user_column_instances_f CINST
194: where TAB.user_table_id = l_table_id