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
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:
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
378: l_employment_category per_all_assignments_f.employment_category%type;
379: l_proc varchar2(35);
380: l_assgt_type varchar2(30);
381: l_prev_assgt_type varchar2(30);
382: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
383: l_tax_office per_all_people_f.per_information6%TYPE;
384: l_one number(1);
385: l_join_variable number(10);
386: l_payroll_id number(10);
379: l_proc varchar2(35);
380: l_assgt_type varchar2(30);
381: l_prev_assgt_type varchar2(30);
382: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
383: l_tax_office per_all_people_f.per_information6%TYPE;
384: l_one number(1);
385: l_join_variable number(10);
386: l_payroll_id number(10);
387: l_contract_category hr_soft_coding_keyflex.segment3%type;
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);
871: l_proc varchar2(44);
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);
871: l_proc varchar2(44);
872: