DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PAY_USER_TABLES

Line 208: FROM pay_user_tables

204: ,p_return_type in varchar2) return number
205: is
206: CURSOR csr_get_user_table_id(l_table_name varchar2) IS
207: SELECT user_table_id
208: FROM pay_user_tables
209: WHERE legislation_code='AE'
210: AND UPPER(user_table_name) = UPPER(l_table_name);
211: CURSOR csr_get_min_low (l_user_table_id NUMBER, l_effective_date DATE) IS
212: SELECT MIN(to_number(row_low_range_or_name))

Line 559: ,pay_user_tables t

555: INTO l_initiator
556: FROM pay_user_column_instances_f i
557: ,pay_user_rows_f r
558: ,pay_user_columns c
559: ,pay_user_tables t
560: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
561: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
562: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
563: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))