[Home] [Help]
862: paf.grade_id grade_id,
863: paf.business_group_id bus_grp_id
864: FROM per_assignments_f paf,
865: per_all_people_f ppf,
866: per_periods_of_service pps
867: WHERE paf.person_id = ppf.person_id
868: AND paf.assignment_id = p_assignment_id
869: AND pps.person_id = ppf.person_id
870: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date
987: -------------
988: /* Cursor to pick Hire Date*/
989: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
990: SELECT date_start
991: FROM per_periods_of_service pps,
992: per_all_assignments_f paa
993: WHERE pps.period_of_service_id = paa.period_of_service_id
994: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
995: AND paa.assignment_id = p_assignment_id;
1051: rec_employer_address csr_employer_address%ROWTYPE;
1052: rec_org_address csr_organization_address%ROWTYPE;
1053: l_nationality per_all_people_f.nationality%TYPE;
1054: l_position per_all_positions.name%TYPE;
1055: l_hire_date per_periods_of_service.date_start%TYPE;
1056: l_grade per_grades.name%TYPE;
1057: l_currency hr_organization_information.org_information10%TYPE;
1058: l_organization hr_organization_units.name%TYPE;
1059: l_pay_location hr_locations_all.address_line_1%TYPE;
3084: IS
3085: -------------
3086: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
3087: SELECT actual_termination_date
3088: FROM per_periods_of_service pps,
3089: per_all_assignments_f paa
3090: WHERE pps.period_of_service_id = paa.period_of_service_id
3091: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
3092: AND paa.assignment_id = p_assignment_id;
3172: FROM pay_all_payrolls_f
3173: WHERE payroll_id = l_payroll_id ;
3174: --------------
3175:
3176: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;
3177: l_tax_card_effective_date DATE;
3178: l_tax_card_type VARCHAR2(50);
3179: l_base_rate NUMBER(5,2);
3180: l_additional_rate NUMBER(5,2);