DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_COLUMNS

Line 43: pay_user_columns puc,

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

Line 76: pay_user_columns puc,

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

Line 179: pay_user_columns c,

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