APPS.PAY_AU_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 52: l_business_group_id per_assignments_f.business_group_id%type ;

48: ,p_original_entry_id number)
49: return date is
50:
51: l_fn_name varchar2(61) := 'pay_au_bal_upload.expiry_date' ;
52: l_business_group_id per_assignments_f.business_group_id%type ;
53: l_asg_start_date per_assignments_f.effective_start_date%type ;
54: l_dimension_start_date date ;
55: l_expiry_date date ; -- expiry_date of the dimension.
56:

Line 53: l_asg_start_date per_assignments_f.effective_start_date%type ;

49: return date is
50:
51: l_fn_name varchar2(61) := 'pay_au_bal_upload.expiry_date' ;
52: l_business_group_id per_assignments_f.business_group_id%type ;
53: l_asg_start_date per_assignments_f.effective_start_date%type ;
54: l_dimension_start_date date ;
55: l_expiry_date date ; -- expiry_date of the dimension.
56:
57: e_bad_expiry_date exception ;

Line 69: from per_assignments_f a

65: (p_assignment_id number
66: ,p_effective_date date) is
67: select greatest (min(a.effective_start_date), min(PTP.start_date))
68: , min(a.business_group_id)
69: from per_assignments_f a
70: ,per_time_periods PTP
71: where a.assignment_id = p_assignment_id
72: and PTP.payroll_id = a.payroll_id
73: and PTP.start_date <= p_effective_date

Line 85: , per_assignments_f paf

81: (p_assignment_id number
82: ,p_upload_date date) is
83: select nvl(ptp.start_date, g_end_of_time)
84: from per_time_periods ptp
85: , per_assignments_f paf
86: where paf.assignment_id = p_assignment_id
87: and p_upload_date between paf.effective_start_date
88: and paf.effective_end_date
89: and ptp.payroll_id = paf.payroll_id