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 2845: from per_all_assignments_f asg

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

Line 2850: l_asg_type per_all_assignments_f.assignment_type%type;

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