DBA Data[Home] [Help]

APPS.HXT_GEN_AAI dependencies on HR_GENERAL

Line 522: ,hr_general.end_of_time --p_effective_end_date

518: ,attribute29
519: ,attribute30)
520: VALUES( p_id
521: ,p_effective_start_date
522: ,hr_general.end_of_time --p_effective_end_date
523: ,p_assignment_id
524: ,p_autogen_hours_yn
525: ,p_rotation_plan
526: ,p_earning_policy

Line 659: AND effective_end_date = hr_general.end_of_time;

655: CURSOR c_delete_rec_eot is
656: SELECT rowid
657: FROM hxt_add_assign_info_f
658: WHERE id = p_id
659: AND effective_end_date = hr_general.end_of_time;
660:
661:
662: -- Bug 8327591
663: -- Added the below cursor to pick up the future records

Line 964: ,hr_general.end_of_time

960: ,attribute30)
961: VALUES
962: (p_id
963: ,p_effective_date
964: ,hr_general.end_of_time
965: ,p_assignment_id
966: ,p_autogen_hours_yn
967: ,p_rotation_plan
968: ,p_earning_policy