DBA Data[Home] [Help]

APPS.HR_AE_VALIDATE_PKG dependencies on PAY_USER_COLUMNS

Line 221: ,pay_user_columns c

217: CURSOR csr_val_mar_status (l_bg_id NUMBER) IS
218: SELECT 'Y'
219: FROM pay_user_column_instances_f i
220: ,pay_user_rows_f r
221: ,pay_user_columns c
222: ,pay_user_tables t
223: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL)
224: OR (i.business_group_id = l_bg_id AND i.legislation_code IS NULL))
225: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL)

Line 943: ,pay_user_columns c

939: ,p_value VARCHAR2) IS
940: SELECT 'Y'
941: FROM pay_user_column_instances_f i
942: ,pay_user_rows_f r
943: ,pay_user_columns c
944: ,pay_user_tables t
945: WHERE i.legislation_code = 'AE'
946: AND r.legislation_code = 'AE'
947: AND c.legislation_code = 'AE'