DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on PAY_USER_TABLES

Line 170: FROM pay_user_tables

166: ,p_return_type in varchar2) return number
167: is
168: CURSOR csr_get_user_table_id(l_table_name varchar2) IS
169: SELECT user_table_id
170: FROM pay_user_tables
171: WHERE legislation_code='AE'
172: AND UPPER(user_table_name) = UPPER(l_table_name);
173: CURSOR csr_get_min_low (l_user_table_id NUMBER, l_effective_date DATE) IS
174: SELECT MIN(to_number(row_low_range_or_name))

Line 493: ,pay_user_tables t

489: INTO l_initiator
490: FROM pay_user_column_instances_f i
491: ,pay_user_rows_f r
492: ,pay_user_columns c
493: ,pay_user_tables t
494: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
495: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
496: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
497: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))