APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 36: l_value pay_user_column_instances_f.value%type;

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

Line 42: from pay_user_column_instances_f puci,

38: --
39: cursor csr_value_match
40: is
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

Line 75: from pay_user_column_instances_f puci,

71: --
72: cursor csr_value_range
73: is
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

Line 177: from pay_user_column_instances_f i,

173: l_value_exists VARCHAR2(1);
174: --
175: CURSOR udt_value_exists IS
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'