APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 194: FROM per_all_assignments_f asg

190: l_eligibility_change VARCHAR2(1);
191:
192: CURSOR csr_get_accrual_elig(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE,p_input_value VARCHAR2) IS
193: SELECT distinct eev.effective_start_date,eev.effective_end_date,eev.screen_entry_value
194: FROM per_all_assignments_f asg
195: ,per_all_people_f per
196: ,pay_element_links_f el
197: ,pay_element_types_f et
198: ,pay_input_values_f iv

Line 221: FROM per_all_assignments_f paa,

217: AND eev.effective_start_date <= p_period_end_date;
218: */
219: CURSOR csr_get_asg_work_pattern(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE) IS
220: SELECT effective_start_date, effective_end_date, segment10
221: FROM per_all_assignments_f paa,
222: hr_soft_coding_keyflex kf
223: WHERE assignment_id = p_assignment_id
224: AND paa.SOFT_CODING_KEYFLEX_ID = kf.SOFT_CODING_KEYFLEX_ID
225: AND ((p_period_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date)

Line 599: per_all_assignments_f paaf

595: CURSOR csr_asg_holidaypay IS
596: SELECT scl.segment19
597: ,scl.segment20
598: FROM hr_soft_coding_keyflex scl,
599: per_all_assignments_f paaf
600: WHERE scl.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
601: AND paaf.assignment_id = p_assignment_id
602: AND p_effective_date between paaf.effective_start_date and effective_end_date;
603: