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 4895: delete from pay_user_column_instances_f

4891:
4892: ELSE
4893: -- Phase = 2
4894:
4895: delete from pay_user_column_instances_f
4896: where user_row_id = r_distinct.c_surrogate_key
4897: and business_group_id is null;
4898:
4899: delete from pay_user_rows_f

Line 4970: insert into pay_user_column_instances_f

4966: into l_null_return
4967: from pay_user_columns
4968: where user_column_id = each_child.user_column_id;
4969:
4970: insert into pay_user_column_instances_f
4971: (user_column_instance_id
4972: ,effective_start_date
4973: ,effective_end_date
4974: ,user_row_id