APPS.PQP_USTIAA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 748: l_asg_id per_all_assignments_f.assignment_id%TYPE;

744: l_ssn per_all_people_f.national_identifier%TYPE;
745: l_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;
749: l_asg_no per_all_assignments_f.assignment_number%TYPE;
750: l_addr1 per_addresses.address_line1%TYPE;
751: l_addr2 per_addresses.address_line2%TYPE;
752: l_addr3 per_addresses.address_line3%TYPE;

Line 749: l_asg_no per_all_assignments_f.assignment_number%TYPE;

745: l_gender per_all_people_f.sex%TYPE;
746: l_gender1 per_all_people_f.sex%TYPE;
747: l_dob per_all_people_f.date_of_birth%TYPE;
748: l_asg_id per_all_assignments_f.assignment_id%TYPE;
749: l_asg_no per_all_assignments_f.assignment_number%TYPE;
750: l_addr1 per_addresses.address_line1%TYPE;
751: l_addr2 per_addresses.address_line2%TYPE;
752: l_addr3 per_addresses.address_line3%TYPE;
753: l_country per_addresses.country%TYPE;

Line 794: from per_all_assignments_f paf

790: padd.town_or_city city,
791: padd.region_2 state,
792: padd.postal_code postal_code,
793: paf.assignment_number
794: from per_all_assignments_f paf
795: , per_all_people_f papf
796: , per_addresses padd
797: where paf.assignment_id = p_asg_id
798: and paf.person_id = papf.person_id

Line 864: FROM per_all_assignments_f paf,

860: CURSOR csr_payroll_details(p_asg_id number,
861: p_date date) IS
862: SELECT prl.prl_information4,
863: prl.period_type
864: FROM per_all_assignments_f paf,
865: pay_payrolls_f prl
866: WHERE paf.assignment_id = p_asg_id
867: AND prl.payroll_id = paf.payroll_id
868: AND prl.prl_information_category = 'US'