APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 727: per_periods_of_service pps

723: paf.grade_id grade_id,
724: paf.business_group_id bus_grp_id
725: FROM per_assignments_f paf,
726: per_all_people_f ppf,
727: per_periods_of_service pps
728: WHERE paf.person_id = ppf.person_id
729: AND paf.assignment_id = p_assignment_id
730: AND pps.person_id = ppf.person_id
731: AND p_date_earned BETWEEN paf.effective_start_date

Line 836: FROM per_periods_of_service pps,

832: WHERE location_id = p_location_id;
833: /* Cursor to pick Hire Date*/
834: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
835: SELECT trunc(date_start) date_start
836: FROM per_periods_of_service pps,
837: per_all_assignments_f paa
838: WHERE pps.period_of_service_id = paa.period_of_service_id
839: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
840: AND paa.assignment_id = p_assignment_id;

Line 855: l_hire_date per_periods_of_service.date_start%TYPE;

851: rec_employer_address csr_employer_address%ROWTYPE;
852: rec_org_address csr_organization_address%ROWTYPE;
853: l_nationality per_all_people_f.nationality%TYPE;
854: l_position per_all_positions.name%TYPE;
855: l_hire_date per_periods_of_service.date_start%TYPE;
856: l_grade per_grades.name%TYPE;
857: l_currency hr_organization_information.org_information10%TYPE;
858: l_organization hr_organization_units.name%TYPE;
859: l_pay_location hr_locations_all.address_line_1%TYPE;

Line 2353: FROM per_periods_of_service pps,

2349: ,p_date_earned IN DATE)
2350: IS
2351: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
2352: SELECT actual_termination_date
2353: FROM per_periods_of_service pps,
2354: per_all_assignments_f paa
2355: WHERE pps.period_of_service_id = paa.period_of_service_id
2356: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
2357: AND paa.assignment_id = p_assignment_id;

Line 2438: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;

2434: FROM pay_balance_attributes
2435: WHERE attribute_id= p_attribute_id;
2436:
2437:
2438: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;
2439: l_tax_card_effective_date DATE;
2440: l_tax_card_type VARCHAR2(50);
2441: l_Tax_Percentage NUMBER(5,2);
2442: l_Tax_Table_Number NUMBER(5,2);