APPS.PQP_USTIAA_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 766: l_hire_date per_periods_of_service.date_start%TYPE;

762: l_postal_code per_addresses.postal_code%TYPE;
763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;
768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;
769: l_plan_no varchar2(6);
770: l_plan_no1 varchar2(6);

Line 767: l_term_date per_periods_of_service.actual_termination_date%TYPE;

763: l_postal_code1 per_addresses.postal_code%TYPE;
764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;
768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;
769: l_plan_no varchar2(6);
770: l_plan_no1 varchar2(6);
771: l_pay_date date;

Line 768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;

764: l_day_phone per_addresses.telephone_number_1%TYPE;
765: l_evening_phone per_addresses.telephone_number_2%TYPE;
766: l_hire_date per_periods_of_service.date_start%TYPE;
767: l_term_date per_periods_of_service.actual_termination_date%TYPE;
768: l_adj_date per_periods_of_service.adjusted_svc_date%TYPE;
769: l_plan_no varchar2(6);
770: l_plan_no1 varchar2(6);
771: l_pay_date date;
772: l_tax_unit_id number;

Line 817: , per_periods_of_service ppos

813: ppos.adjusted_svc_date
814: from per_all_assignments_f paf
815: , per_all_people_f papf
816: , per_addresses padd
817: , per_periods_of_service ppos
818: where paf.assignment_id = p_asg_id
819: and paf.person_id = papf.person_id
820: and padd.person_id = papf.person_id
821: and paf.person_id = ppos.person_id