[Home] [Help]
684: paf.grade_id grade_id,
685: paf.business_group_id bus_grp_id
686: FROM per_assignments_f paf,
687: per_all_people_f ppf,
688: per_periods_of_service pps
689: WHERE paf.person_id = ppf.person_id
690: AND paf.assignment_id = p_assignment_id
691: AND pps.person_id = ppf.person_id
692: AND p_date_earned BETWEEN paf.effective_start_date
793: WHERE location_id = p_location_id;
794: /* Cursor to pick Hire Date*/
795: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
796: SELECT trunc(date_start) date_start
797: FROM per_periods_of_service pps,
798: per_all_assignments_f paa
799: WHERE pps.period_of_service_id = paa.period_of_service_id
800: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
801: AND paa.assignment_id = p_assignment_id;
812: rec_employer_address csr_employer_address%ROWTYPE;
813: rec_org_address csr_organization_address%ROWTYPE;
814: l_nationality per_all_people_f.nationality%TYPE;
815: l_position per_all_positions.name%TYPE;
816: l_hire_date per_periods_of_service.date_start%TYPE;
817: l_grade per_grades.name%TYPE;
818: l_currency hr_organization_information.org_information10%TYPE;
819: l_organization hr_organization_units.name%TYPE;
820: l_pay_location hr_locations_all.address_line_1%TYPE;
1802: ,p_date_earned IN DATE)
1803: IS
1804: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
1805: SELECT actual_termination_date
1806: FROM per_periods_of_service pps,
1807: per_all_assignments_f paa
1808: WHERE pps.period_of_service_id = paa.period_of_service_id
1809: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
1810: AND paa.assignment_id = p_assignment_id;
1887: FROM pay_balance_attributes
1888: WHERE attribute_id= p_attribute_id;
1889:
1890:
1891: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;
1892: l_tax_card_effective_date DATE;
1893: l_tax_card_type VARCHAR2(50);
1894: l_base_rate NUMBER(5,2);
1895: l_additional_rate NUMBER(5,2);