APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 32: l_value pay_user_column_instances_f.value%type;

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
36: is

Line 38: from pay_user_column_instances_f puci,

34: --
35: cursor csr_value_match
36: is
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

Line 71: from pay_user_column_instances_f puci,

67: --
68: cursor csr_value_range
69: is
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

Line 173: from pay_user_column_instances_f i,

169: l_value_exists VARCHAR2(1);
170: --
171: CURSOR udt_value_exists IS
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'