APPS.PAY_GB_RTI_EYU dependencies on PER_ASSIGNMENTS_F

Line 660: l_asg_number per_assignments_f.assignment_number%TYPE;

656: l_expat_rec csr_get_expat_details%rowtype;
657: l_stay_over_6_months VARCHAR2(1);
658: l_stay_less_6_months VARCHAR2(1);
659: l_working_in_out_UK VARCHAR2(1);
660: l_asg_number per_assignments_f.assignment_number%TYPE;
661:
662: l_starter_decl VARCHAR2(30);
663: l_continue_with_student_loan VARCHAR2(30);
664: l_ovn NUMBER;

Line 2648: l_assignment_number per_assignments_f.assignment_number%TYPE;

2644:
2645: l_proc CONSTANT VARCHAR2(70):= g_package||'person_address_validations';
2646:
2647: --Assignment Number
2648: l_assignment_number per_assignments_f.assignment_number%TYPE;
2649:
2650: -- Address details
2651: l_address_line1 per_addresses.address_line1%TYPE;
2652: l_address_line2 per_addresses.address_line2%TYPE;

Line 2924: l_assignment_number per_assignments_f.assignment_number%TYPE;

2920: --Declarations
2921: l_proc CONSTANT VARCHAR2(70):= g_package||'assignment_validations';
2922:
2923: -- Assignment Number
2924: l_assignment_number per_assignments_f.assignment_number%TYPE;
2925:
2926: -- Assignment Fields
2927: l_start_date date;
2928: l_end_date date;

Line 2936: l_payroll_id per_assignments_f.assignment_number%TYPE;

2932: l_stay_less_six_months varchar2(100);
2933: l_living_abroad varchar2(100);
2934: l_occ_pension_indicator varchar2(100);
2935: l_annual_occupational_pension number;
2936: l_payroll_id per_assignments_f.assignment_number%TYPE;
2937: l_taxable_pay_to_date number;
2938: l_student_loan_repayment number;
2939: l_student_loan_repay number;
2940: l_tax_deducted_refunded number;

Line 3180: l_assignment_number per_assignments_f.assignment_number%TYPE;

3176:
3177:
3178: --Declarations
3179: l_proc CONSTANT VARCHAR2(70):= g_package||'ni_validations';
3180: l_assignment_number per_assignments_f.assignment_number%TYPE;
3181:
3182: -- NI Fields
3183: l_ni_category varchar2(2);
3184: l_earnings_lel number;

Line 3827: l_rti_payroll_id per_assignments_f.assignment_number%TYPE;

3823:
3824: l_tax_ref VARCHAR2(20);
3825: l_business_group_id NUMBER;
3826: l_effective_date DATE;
3827: l_rti_payroll_id per_assignments_f.assignment_number%TYPE;
3828: l_flag varchar2(1) := 'Y';
3829: l_fps_run_date date;
3830: l_last_asg_action_id number;
3831: l_last_effective_date date;

Line 5328: l_asg_no per_assignments_f.assignment_number%TYPE;

5324: l_asg_id number;
5325: l_person_id NUMBER;
5326: l_last_asg_action_id number;
5327: l_last_effective_date date;
5328: l_asg_no per_assignments_f.assignment_number%TYPE;
5329:
5330: l_last_fps_pactid number := NULL;
5331: l_last_fps_effdate date;
5332: l_flag VARCHAR2(1) := 'N';