APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 339: from per_all_assignments_f

335: where pay_proposal_id = p_pay_proposal_id;
336: --
337: cursor c_asg_pay_basis_id(p_assignment_id number, p_date date) is
338: select pay_basis_id
339: from per_all_assignments_f
340: where assignment_id = p_assignment_id
341: and p_date between effective_start_date and effective_end_date;
342: --
343: l_proc varchar2(72) := g_package||'extend_salary_proposal_to_date';

Line 517: per_all_assignments_f asg

513: from
514: pay_element_types_f pet,
515: pay_input_values_f piv,
516: per_pay_bases ppb,
517: per_all_assignments_f asg
518:
519: where
520: pet.element_type_id = piv.element_type_id
521: and p_change_date BETWEEN pet.effective_start_date

Line 2843: from per_all_assignments_f asg

2839: where assignment_id=p_assignment_id;
2840: --
2841: cursor asg_type is
2842: select asg.assignment_type
2843: from per_all_assignments_f asg
2844: where asg.assignment_id=p_assignment_id
2845: and p_change_date between asg.effective_start_date
2846: and asg.effective_end_date;
2847: --

Line 2848: l_asg_type per_all_assignments_f.assignment_type%type;

2844: where asg.assignment_id=p_assignment_id
2845: and p_change_date between asg.effective_start_date
2846: and asg.effective_end_date;
2847: --
2848: l_asg_type per_all_assignments_f.assignment_type%type;
2849: --
2850: begin
2851: --
2852: hr_utility.set_location('Entering:'|| l_proc, 10);