DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 174: -- from pay_user_column_instances_f

170: -- 115.24 vmehta 07-DEC-99 Added report_format in
171: -- pay_report_format_mappings_f update
172: -- clause in transfer_row procedure.
173: -- 115.25 ablinko 08-DEC-99 Only delete rows with no buisness group
174: -- from pay_user_column_instances_f
175: -- 115.26 tbattoo 08-Feb-00 changed crt_exc so calls
176: -- hr_legislation.insert_hr_stu_exceptions
177: -- This is an autonomous transaction procedure
178: -- , so we dont loose error messages on rollback

Line 5145: delete from pay_user_column_instances_f

5141:
5142: ELSE
5143: -- Phase = 2
5144:
5145: delete from pay_user_column_instances_f
5146: where user_row_id = r_distinct.c_surrogate_key
5147: and business_group_id is null;
5148:
5149: delete from pay_user_rows_f

Line 5220: insert into pay_user_column_instances_f

5216: into l_null_return
5217: from pay_user_columns
5218: where user_column_id = each_child.user_column_id;
5219:
5220: insert into pay_user_column_instances_f
5221: (user_column_instance_id
5222: ,effective_start_date
5223: ,effective_end_date
5224: ,user_row_id