APPS.PAY_IE_SB_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 49: FROM per_all_assignments_f

45: l_absence_end_date date;
46: l_proc varchar2(72) := g_package||'create_ie_sb_details';
47: CURSOR business_group_csr IS
48: SELECT business_group_id
49: FROM per_all_assignments_f
50: WHERE assignment_id = p_assignment_id
51: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
52: --
53: l_benefit_amount pay_ie_social_benefits_f.benefit_amount%type := p_benefit_amount;

Line 255: FROM per_all_assignments_f

251: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
252: --
253: CURSOR business_group_csr IS
254: SELECT business_group_id
255: FROM per_all_assignments_f
256: WHERE assignment_id = l_assignment_id
257: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
258: --
259: t_calculation_option pay_ie_social_benefits_f.calculation_option%type;

Line 476: FROM per_all_assignments_f

472: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
473: --
474: CURSOR business_group_csr IS
475: SELECT business_group_id
476: FROM per_all_assignments_f
477: WHERE assignment_id = l_assignment_id
478: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
479: begin
480: hr_utility.set_location('Entering:'|| l_proc, 10);