APPS.PER_PL_ASSIGNMENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 26: from per_assignment_status_types paat , per_all_assignments_f paaf

22: and r_date between effective_start_date and effective_end_date;
23:
24: cursor csr_assgt_type(r_assignment_id number,r_date date) is
25: select per_system_status
26: from per_assignment_status_types paat , per_all_assignments_f paaf
27: where paat.assignment_status_type_id=paaf.assignment_status_type_id
28: and assignment_id=r_assignment_id
29: and r_date between effective_start_date and effective_end_date;
30: function get_person_id(l_assignment_id number,l_date date) return number is

Line 866: l_assgt_type per_assignment_status_types.per_system_status%type;

862: and paaf.effective_start_date between effective_start_date and effective_end_date
863: and assignment_id=p_assignment_id;
864: l_contract_category hr_soft_coding_keyflex.segment3%type;
865: l_join_variable number(10);
866: l_assgt_type per_assignment_status_types.per_system_status%type;
867: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
868: l_tax_office per_all_people_f.per_information6%TYPE;
869: l_one number(1);
870: l_person_id number(10);