APPS.HR_AE_VALIDATE_PKG dependencies on PAY_USER_COLUMNS

Line 227: ,pay_user_columns c

223: CURSOR csr_val_mar_status (l_bg_id NUMBER) IS
224: SELECT 'Y'
225: FROM pay_user_column_instances_f i
226: ,pay_user_rows_f r
227: ,pay_user_columns c
228: ,pay_user_tables t
229: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL)
230: OR (i.business_group_id = l_bg_id AND i.legislation_code IS NULL))
231: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL)

Line 952: ,pay_user_columns c

948: ,p_value VARCHAR2) IS
949: SELECT 'Y'
950: FROM pay_user_column_instances_f i
951: ,pay_user_rows_f r
952: ,pay_user_columns c
953: ,pay_user_tables t
954: WHERE ((i.legislation_code = 'AE' and i.business_group_id is null) or (i.legislation_code is NULL and i.business_group_id = p_business_group_id))
955: AND ((r.legislation_code = 'AE' and r.business_group_id is null) or (r.legislation_code is NULL and r.business_group_id = p_business_group_id))
956: AND ((c.legislation_code = 'AE' and c.business_group_id is null) or (c.legislation_code is NULL and c.business_group_id = p_business_group_id))