APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_TABLES

Line 34: l_range_or_match pay_user_tables.range_or_match%type;

30: RETURN VARCHAR2
31: IS
32: --
33: l_effective_date date;
34: l_range_or_match pay_user_tables.range_or_match%type;
35: l_user_table_id pay_user_tables.user_table_id%type;
36: l_value pay_user_column_instances_f.value%type;
37: l_legislation_code per_business_groups.legislation_code%type;
38: --

Line 35: l_user_table_id pay_user_tables.user_table_id%type;

31: IS
32: --
33: l_effective_date date;
34: l_range_or_match pay_user_tables.range_or_match%type;
35: l_user_table_id pay_user_tables.user_table_id%type;
36: l_value pay_user_column_instances_f.value%type;
37: l_legislation_code per_business_groups.legislation_code%type;
38: --
39: cursor csr_value_match

Line 45: pay_user_tables put

41: select puci.value
42: from pay_user_column_instances_f puci,
43: pay_user_columns puc,
44: pay_user_rows_f pur,
45: pay_user_tables put
46: where put.user_table_id = l_user_table_id
47: and pur.user_table_id = put.user_table_id
48: and l_effective_date
49: between pur.effective_start_date and pur.effective_end_date

Line 78: pay_user_tables put

74: select puci.value
75: from pay_user_column_instances_f puci,
76: pay_user_columns puc,
77: pay_user_rows_f pur,
78: pay_user_tables put
79: where put.user_table_id = l_user_table_id
80: and put.user_key_units = 'N'
81: and pur.user_table_id = put.user_table_id
82: and l_effective_date

Line 120: from pay_user_tables

116: select range_or_match,
117: user_table_id
118: into l_range_or_match,
119: l_user_table_id
120: from pay_user_tables
121: where user_table_name = p_table_name
122: and nvl(business_group_id, p_business_group_id) = p_business_group_id
123: and nvl(legislation_code, l_legislation_code) = l_legislation_code;
124: --

Line 180: pay_user_tables t

176: select 'Y'
177: from pay_user_column_instances_f i,
178: pay_user_rows_f r,
179: pay_user_columns c,
180: pay_user_tables t
181: where t.legislation_code ='JP'
182: and t.business_group_id is null
183: and t.user_table_name = p_table_name
184: and c.legislation_code = 'JP'