APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on PER_ASSIGNMENTS_F

Line 241: l_assignment_number per_assignments_f.assignment_number%TYPE;

237:
238: l_proc CONSTANT VARCHAR2(70):= g_package||'person_address_validations';
239:
240: --Assignment Number
241: l_assignment_number per_assignments_f.assignment_number%TYPE;
242:
243: -- Address details
244: l_address_line1 per_addresses.address_line1%TYPE;
245: l_address_line2 per_addresses.address_line2%TYPE;

Line 513: l_assignment_number per_assignments_f.assignment_number%TYPE;

509:
510: l_proc CONSTANT VARCHAR2(70):= g_package||'person_addr_validations_aggr';
511:
512: --Assignment Number
513: l_assignment_number per_assignments_f.assignment_number%TYPE;
514:
515: -- Address details
516: l_address_line1 per_addresses.address_line1%TYPE;
517: l_address_line2 per_addresses.address_line2%TYPE;

Line 804: l_assignment_number per_assignments_f.assignment_number%TYPE;

800: --Declarations
801: l_proc CONSTANT VARCHAR2(70):= g_package||'assignment_validations';
802:
803: -- Assignment Number
804: l_assignment_number per_assignments_f.assignment_number%TYPE;
805:
806: -- Assignment Fields
807: l_start_date date;
808: l_end_date date;

Line 1334: l_assignment_number per_assignments_f.assignment_number%TYPE;

1330: --Declarations
1331: l_proc CONSTANT VARCHAR2(70):= g_package||'assignment_validations_aggr';
1332:
1333: -- Assignment Number
1334: l_assignment_number per_assignments_f.assignment_number%TYPE;
1335:
1336: -- Assignment Fields
1337: l_start_date date;
1338: l_end_date date;

Line 1860: l_assignment_number per_assignments_f.assignment_number%TYPE;

1856:
1857:
1858: --Declarations
1859: l_proc CONSTANT VARCHAR2(70):= g_package||'ni_validations';
1860: l_assignment_number per_assignments_f.assignment_number%TYPE;
1861:
1862: -- NI Fields
1863: l_ni_category varchar2(2);
1864: l_pay_to_nic number;