DBA Data[Home] [Help]

APPS.HR_AE_VALIDATE_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 225: FROM pay_user_column_instances_f i

221: AND pty.business_group_id = hoi.organization_id;
222:
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)

Line 950: FROM pay_user_column_instances_f i

946: ,p_row_low_name VARCHAR2
947: ,p_user_column_name VARCHAR2
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))