[Home] [Help]
1099: fnd_date.date_to_canonical(pap.date_of_birth) date_of_birth,
1100: fnd_date.date_to_canonical(decode(pap.current_employee_flag, 'Y', serv.date_start, null)) hire_date
1101: from pay_assignment_actions act,
1102: per_assignments_f paa,
1103: per_people_f pap,
1104: per_periods_of_service serv
1105: where act.assignment_action_id = p_assactid
1106: and act.assignment_id = paa.assignment_id
1107: and paa.person_id = pap.person_id
1577: l_ovn number;
1578: l_action_id number;
1579: --edi_validation_fail varchar2(50);
1580:
1581: l_sex per_people_f.sex%TYPE;
1582: l_assignment_number per_assignments_f.assignment_number%TYPE;
1583: l_date_of_birth varchar2(100);
1584: l_tax_code_in_use varchar2(100);
1585: l_tax_basis_in_use varchar2(100);
1704: l_action_id number;
1705: --edi_validation_fail varchar2(50);
1706:
1707:
1708: l_national_insurance_number per_people_f.national_identifier%TYPE;
1709: l_assignment_number per_assignments_f.assignment_number%TYPE;
1710: l_address_line1 per_addresses.address_line1%TYPE;
1711: l_address_line2 per_addresses.address_line2%TYPE;
1712: l_address_line3 per_addresses.address_line3%TYPE;
1713: l_address_line4 per_addresses.address_line3%TYPE;
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;
1720: l_title per_people_f.title%TYPE;
1721: l_job_title varchar(100);
1714: l_town_or_city per_addresses.town_or_city%TYPE;
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;
1720: l_title per_people_f.title%TYPE;
1721: l_job_title varchar(100);
1722: l_tax_code varchar(100);
1715: l_county per_addresses.region_1%TYPE;
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;
1720: l_title per_people_f.title%TYPE;
1721: l_job_title varchar(100);
1722: l_tax_code varchar(100);
1723: l_tax_basis varchar(10);
1716: l_postal_code per_addresses.postal_code%TYPE;
1717: l_last_name per_people_f.last_name%TYPE;
1718: l_first_name per_people_f.first_name%TYPE;
1719: l_middle_name per_people_f.middle_names%TYPE;
1720: l_title per_people_f.title%TYPE;
1721: l_job_title varchar(100);
1722: l_tax_code varchar(100);
1723: l_tax_basis varchar(10);
1724: l_assignment_id number;
1721: l_job_title varchar(100);
1722: l_tax_code varchar(100);
1723: l_tax_basis varchar(10);
1724: l_assignment_id number;
1725: l_national_identifier per_people_f.national_identifier%TYPE;
1726:
1727: l_session_date date;
1728: l_count_char_errors number;
1729: l_count_missing_val number;
2533: END IF;
2534: /* Changes for P45PT3 end*/
2535:
2536: sqlstr := 'select distinct person_id '||
2537: 'from per_people_f ppf, '||
2538: 'pay_payroll_actions ppa '||
2539: 'where ppa.payroll_action_id = :payroll_action_id '||
2540: 'and ppa.business_group_id = ppf.business_group_id '||
2541: 'order by ppf.person_id';
2684: l_err BOOLEAN := False;
2685:
2686: l_tax_code_in_use VARCHAR2(50);
2687: l_assignment_number per_assignments_f.assignment_number%TYPE;
2688: l_sex per_people_f.sex%TYPE;
2689: l_date_of_birth VARCHAR2(100);
2690: l_hire_date VARCHAR2(100);
2691: l_tax_basis_in_use VARCHAR2(50);
2692: