DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_COLUMNS

Line 39: pay_user_columns puc,

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
43: and pur.user_table_id = put.user_table_id

Line 72: pay_user_columns puc,

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
76: and put.user_key_units = 'N'

Line 175: pay_user_columns c,

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'
178: and t.business_group_id is null
179: and t.user_table_name = p_table_name