APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 1281: per_periods_of_service pps

1277: paf.business_group_id bus_grp_id,
1278: paf.assignment_number asg_num
1279: FROM per_assignments_f paf,
1280: per_all_people_f ppf,
1281: per_periods_of_service pps
1282: WHERE paf.person_id = ppf.person_id
1283: AND paf.assignment_id = p_assignment_id
1284: AND pps.person_id = ppf.person_id
1285: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 1407: FROM per_periods_of_service pps,

1403: -------------
1404: /* Cursor to pick Hire Date*/
1405: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
1406: SELECT date_start
1407: FROM per_periods_of_service pps,
1408: per_all_assignments_f paa
1409: WHERE pps.period_of_service_id = paa.period_of_service_id
1410: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
1411: AND paa.assignment_id = p_assignment_id;

Line 1466: l_hire_date per_periods_of_service.date_start%TYPE;

1462: rec_employer_address csr_employer_address%ROWTYPE;
1463: rec_org_address csr_organization_address%ROWTYPE;
1464: l_nationality per_all_people_f.nationality%TYPE;
1465: l_position per_all_positions.name%TYPE;
1466: l_hire_date per_periods_of_service.date_start%TYPE;
1467: l_grade per_grades.name%TYPE;
1468: l_currency hr_organization_information.org_information10%TYPE;
1469: l_organization hr_organization_units.name%TYPE;
1470: l_pay_location hr_locations_all.address_line_1%TYPE;

Line 3852: FROM per_periods_of_service pps,

3848: IS
3849: -------------
3850: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
3851: SELECT actual_termination_date
3852: FROM per_periods_of_service pps,
3853: per_all_assignments_f paa
3854: WHERE pps.period_of_service_id = paa.period_of_service_id
3855: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
3856: AND paa.assignment_id = p_assignment_id;

Line 3967: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;

3963: AND l_eff_date BETWEEN r.effective_start_date AND r.effective_end_date;
3964:
3965: ------------------------------------------------
3966:
3967: l_actual_termination_date PER_PERIODS_OF_SERVICE.ACTUAL_TERMINATION_DATE%TYPE;
3968: l_tax_card_effective_date DATE;
3969: l_tax_card_type VARCHAR2(50);
3970: l_base_rate NUMBER(5,2);
3971: l_additional_rate NUMBER(5,2);