DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on PAY_USER_ROWS_F

Line 40: pay_user_rows_f pur,

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

Line 73: pay_user_rows_f pur,

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

Line 174: pay_user_rows_f r,

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