DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_ROWS_F

Line 44: pay_user_rows_f pur,

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
48: and l_effective_date

Line 77: pay_user_rows_f pur,

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

Line 178: pay_user_rows_f r,

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