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 1007: l_assgt_type per_assignment_status_types.per_system_status%type;

1003: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
1004:
1005: l_contract_category hr_soft_coding_keyflex.segment3%type;
1006: l_join_variable number(10);
1007: l_assgt_type per_assignment_status_types.per_system_status%type;
1008: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
1009: l_tax_office per_all_people_f.per_information6%TYPE;
1010: l_employment_category per_all_assignments_f.employment_category%TYPE;
1011: l_one number(1);