APPS.BEN_PRO_LER dependencies on PER_ALL_ASSIGNMENTS_F

Line 29: per_all_assignments_f asg

25: ,p_effective_date in date)
26: is
27: select a.person_id
28: from per_all_people_f a,
29: per_all_assignments_f asg
30: where a.person_id = asg.person_id
31: and asg.assignment_id = p_assignment_id
32: and asg.business_group_id = a.business_group_id
33: and p_effective_date

Line 1001: l_assignment_id per_all_assignments_f.assignment_id%type;

997: l_old_max_val number;
998: l_old_min_val number;
999: l_new_max_val number;
1000: l_new_min_val number;
1001: l_assignment_id per_all_assignments_f.assignment_id%type;
1002: l_business_group_id per_all_assignments_f.business_group_id%type;
1003: l_old_grade_id number;
1004: l_new_grade_id number;
1005: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 1002: l_business_group_id per_all_assignments_f.business_group_id%type;

998: l_old_min_val number;
999: l_new_max_val number;
1000: l_new_min_val number;
1001: l_assignment_id per_all_assignments_f.assignment_id%type;
1002: l_business_group_id per_all_assignments_f.business_group_id%type;
1003: l_old_grade_id number;
1004: l_new_grade_id number;
1005: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1006: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 1005: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type;

1001: l_assignment_id per_all_assignments_f.assignment_id%type;
1002: l_business_group_id per_all_assignments_f.business_group_id%type;
1003: l_old_grade_id number;
1004: l_new_grade_id number;
1005: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1006: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1007: l_quar_in_grade_cd varchar2(30);
1008: l_old_person_sal number;
1009: l_new_person_sal number;

Line 1006: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type;

1002: l_business_group_id per_all_assignments_f.business_group_id%type;
1003: l_old_grade_id number;
1004: l_new_grade_id number;
1005: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1006: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type;
1007: l_quar_in_grade_cd varchar2(30);
1008: l_old_person_sal number;
1009: l_new_person_sal number;
1010: l_change_date date;

Line 1067: from per_all_assignments_f

1063: order by 2 desc ;
1064: --
1065: cursor c_asg(p_person_id number,p_business_group_id number,p_assignment_id number) is
1066: select grade_id,pay_basis_id
1067: from per_all_assignments_f
1068: where assignment_id = p_assignment_id
1069: and person_id = p_person_id
1070: and business_group_id = p_business_group_id
1071: and l_session_date between effective_start_date and effective_end_date;