DBA Data[Home] [Help]

APPS.PAY_FR_SCHEDULE_CALCULATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 48: from per_all_assignments_f a

44: , a.person_id
45: , a.business_group_id business_group_id
46: , scl.segment5 work_pattern
47: , nvl(scl.segment11,g_default_offset) work_pattern_start_day
48: from per_all_assignments_f a
49: , hr_soft_coding_keyflex scl
50: where a.assignment_id = p_assignment_id
51: and a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
52: order by a.effective_start_date;

Line 633: From per_all_assignments_f paaf

629: l_act_date Date;
630: l_last_act_date Date;
631: Cursor c_start_asg is
632: Select Min(effective_start_date)
633: From per_all_assignments_f paaf
634: Where
635: paaf.assignment_id = g_assignment_id;
636:
637: begin