224:
225: l_proc CONSTANT VARCHAR2(70):= g_package||'person_address_validations';
226:
227: --Assignment Number
228: l_assignment_number per_assignments_f.assignment_number%TYPE;
229:
230: -- Address details
231: l_address_line1 per_addresses.address_line1%TYPE;
232: l_address_line2 per_addresses.address_line2%TYPE;
496:
497: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';
498:
499: --Assignment Number
500: l_assignment_number per_assignments_f.assignment_number%TYPE;
501:
502: -- Address details
503: l_address_line1 per_addresses.address_line1%TYPE;
504: l_address_line2 per_addresses.address_line2%TYPE;
787: --Declarations
788: l_proc CONSTANT VARCHAR2(70):= g_package||'assignment_validations';
789:
790: -- Assignment Number
791: l_assignment_number per_assignments_f.assignment_number%TYPE;
792:
793: -- Assignment Fields
794: l_start_date date;
795: l_end_date date;
1317: --Declarations
1318: l_proc CONSTANT VARCHAR2(70):= g_package||'assignment_validations_aggr';
1319:
1320: -- Assignment Number
1321: l_assignment_number per_assignments_f.assignment_number%TYPE;
1322:
1323: -- Assignment Fields
1324: l_start_date date;
1325: l_end_date date;
1843:
1844:
1845: --Declarations
1846: l_proc CONSTANT VARCHAR2(70):= g_package||'ni_validations';
1847: l_assignment_number per_assignments_f.assignment_number%TYPE;
1848:
1849: -- NI Fields
1850: l_ni_category varchar2(2);
1851: l_pay_to_nic number;