APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 157: FROM per_all_assignments_f asg

153: l_eligibility_change VARCHAR2(1);
154:
155: CURSOR csr_get_accrual_elig(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE,p_input_value VARCHAR2) IS
156: SELECT distinct eev.effective_start_date,eev.effective_end_date,eev.screen_entry_value
157: FROM per_all_assignments_f asg
158: ,per_all_people_f per
159: ,pay_element_links_f el
160: ,pay_element_types_f et
161: ,pay_input_values_f iv

Line 181: FROM per_all_assignments_f paa,

177: AND eev.effective_start_date <= p_period_end_date;
178:
179: CURSOR csr_get_asg_work_pattern(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE) IS
180: SELECT effective_start_date, effective_end_date, segment10
181: FROM per_all_assignments_f paa,
182: hr_soft_coding_keyflex kf
183: WHERE assignment_id = p_assignment_id
184: AND paa.SOFT_CODING_KEYFLEX_ID = kf.SOFT_CODING_KEYFLEX_ID
185: AND ((p_period_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date)

Line 559: per_all_assignments_f paaf

555: CURSOR csr_asg_holidaypay IS
556: SELECT scl.segment19
557: ,scl.segment20
558: FROM hr_soft_coding_keyflex scl,
559: per_all_assignments_f paaf
560: WHERE scl.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
561: AND paaf.assignment_id = p_assignment_id
562: AND p_effective_date between paaf.effective_start_date and effective_end_date;
563: