APPS.PER_PL_ASSIGNMENT dependencies on PER_ALL_PEOPLE_F

Line 8: from per_all_people_f

4: g_package_name varchar2(18);
5:
6: cursor csr_oldage_taxoffice_check(r_person_id in number,r_date date) is
7: select per_information4,per_information6
8: from per_all_people_f
9: where person_id=r_person_id
10: and r_date between effective_start_date and effective_end_date ;
11:
12: cursor csr_check_sii_exists(r_join_variable in number,r_date date) is

Line 74: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;

70: ,p_employment_category varchar2
71: ) is
72:
73: l_proc varchar2(45);
74: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
75: l_tax_office per_all_people_f.per_information6%TYPE;
76: l_one number(1);
77: l_join_variable number(10);
78:

Line 75: l_tax_office per_all_people_f.per_information6%TYPE;

71: ) is
72:
73: l_proc varchar2(45);
74: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
75: l_tax_office per_all_people_f.per_information6%TYPE;
76: l_one number(1);
77: l_join_variable number(10);
78:
79: begin

Line 408: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;

404: l_employment_category per_all_assignments_f.employment_category%type;
405: l_proc varchar2(35);
406: l_assgt_type varchar2(30);
407: l_prev_assgt_type varchar2(30);
408: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
409: l_tax_office per_all_people_f.per_information6%TYPE;
410: l_one number(1);
411: l_join_variable number(10);
412: l_payroll_id number(10);

Line 409: l_tax_office per_all_people_f.per_information6%TYPE;

405: l_proc varchar2(35);
406: l_assgt_type varchar2(30);
407: l_prev_assgt_type varchar2(30);
408: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
409: l_tax_office per_all_people_f.per_information6%TYPE;
410: l_one number(1);
411: l_join_variable number(10);
412: l_payroll_id number(10);
413: l_contract_category hr_soft_coding_keyflex.segment3%type;

Line 1008: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;

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);
1012: l_person_id number(10);

Line 1009: l_tax_office per_all_people_f.per_information6%TYPE;

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);
1012: l_person_id number(10);
1013: l_proc varchar2(44);