DBA Data[Home] [Help]

APPS.HR_ORGANIZATION dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 155: insert rows into pay_user_column_instances_f

151: because the latest version of translated table
152: PER_STARTUP_PERSON_TYPES_TL now has column
153: DEFAULT_FLAG.
154: 115.11 11-JUN-99 MElori-M Added cursor get_usr_rows and code to
155: insert rows into pay_user_column_instances_f
156: whenever a new business group is created.
157: Added commit statement at the end of package
158: script.
159: 115.12 03-NOV-99 STee Added call to seed regulations.

Line 733: INSERT INTO pay_user_column_instances_f

729: --
730: hr_utility.set_location('hr_organization.insert_bus_grp_details',10);
731: -- VT added condition for Org API call
732: IF NOT hr_ori_shd.return_api_dml_status THEN
733: INSERT INTO pay_user_column_instances_f
734: (user_column_instance_id
735: ,effective_start_date
736: ,effective_end_date
737: ,user_row_id

Line 766: INSERT INTO pay_user_column_instances_f

762: ,p_creation_date
763: FROM fnd_sessions
764: WHERE session_id = userenv('sessionid');
765: ELSE
766: INSERT INTO pay_user_column_instances_f
767: (user_column_instance_id
768: ,effective_start_date
769: ,effective_end_date
770: ,user_row_id