DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 9200: FROM per_all_assignments_f asg,

9196: -- bug 5295672
9197: cursor c_get_normal_hours (p_assignment_id in number) is
9198: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
9199: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
9200: FROM per_all_assignments_f asg,
9201: per_business_groups pbg
9202: WHERE asg.assignment_id = p_assignment_id
9203: AND asg.business_group_id = pbg.business_group_id
9204: AND p_effective_date between asg.effective_start_date

Line 9409: FROM per_all_assignments_f asg,

9405: -- bug 5295672
9406: cursor c_get_normal_hours (p_assignment_id in number) is
9407: select nvl(nvl(asg.time_normal_start, pbg.default_start_time), '00:00'),
9408: nvl(nvl(asg.time_normal_finish, pbg.default_end_time), '23:59')
9409: FROM per_all_assignments_f asg,
9410: per_business_groups pbg
9411: WHERE asg.assignment_id = p_assignment_id
9412: AND asg.business_group_id = pbg.business_group_id
9413: AND p_effective_date between asg.effective_start_date