APPS.PAY_AU_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 53: l_business_group_id per_assignments_f.business_group_id%type ;

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

Line 54: l_asg_start_date per_assignments_f.effective_start_date%type ;

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

Line 70: from per_assignments_f a

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

Line 87: , per_assignments_f paf

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