APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_TABLES

Line 30: l_range_or_match pay_user_tables.range_or_match%type;

26: RETURN VARCHAR2
27: IS
28: --
29: l_effective_date date;
30: l_range_or_match pay_user_tables.range_or_match%type;
31: l_user_table_id pay_user_tables.user_table_id%type;
32: l_value pay_user_column_instances_f.value%type;
33: l_legislation_code per_business_groups.legislation_code%type;
34: --

Line 31: l_user_table_id pay_user_tables.user_table_id%type;

27: IS
28: --
29: l_effective_date date;
30: l_range_or_match pay_user_tables.range_or_match%type;
31: l_user_table_id pay_user_tables.user_table_id%type;
32: l_value pay_user_column_instances_f.value%type;
33: l_legislation_code per_business_groups.legislation_code%type;
34: --
35: cursor csr_value_match

Line 41: pay_user_tables put

37: select puci.value
38: from pay_user_column_instances_f puci,
39: pay_user_columns puc,
40: pay_user_rows_f pur,
41: pay_user_tables put
42: where put.user_table_id = l_user_table_id
43: and pur.user_table_id = put.user_table_id
44: and l_effective_date
45: between pur.effective_start_date and pur.effective_end_date

Line 74: pay_user_tables put

70: select puci.value
71: from pay_user_column_instances_f puci,
72: pay_user_columns puc,
73: pay_user_rows_f pur,
74: pay_user_tables put
75: where put.user_table_id = l_user_table_id
76: and put.user_key_units = 'N'
77: and pur.user_table_id = put.user_table_id
78: and l_effective_date

Line 116: from pay_user_tables

112: select range_or_match,
113: user_table_id
114: into l_range_or_match,
115: l_user_table_id
116: from pay_user_tables
117: where user_table_name = p_table_name
118: and nvl(business_group_id, p_business_group_id) = p_business_group_id
119: and nvl(legislation_code, l_legislation_code) = l_legislation_code;
120: --

Line 176: pay_user_tables t

172: select 'Y'
173: from pay_user_column_instances_f i,
174: pay_user_rows_f r,
175: pay_user_columns c,
176: pay_user_tables t
177: where t.legislation_code ='JP'
178: and t.business_group_id is null
179: and t.user_table_name = p_table_name
180: and c.legislation_code = 'JP'