eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_P45_PKG dependencies on PER_ADDRESSES

Line 537: from per_addresses addr

533: addr.TOWN_OR_CITY,
534: addr.REGION_1,
535: addr.COUNTRY,
536: addr.POSTAL_CODE
537: from per_addresses addr
538: where addr.PERSON_ID = X_PERSON_ID
539: and addr.PRIMARY_FLAG = 'Y'
540: and p_effective_date between
541: addr.DATE_FROM and

Line 551: l_county per_addresses.region_1%type /varchar2(30)/;

547: where ftv.territory_code = p_code;
548:
549: l_addr c_addr%rowtype;
550: l_found boolean;
551: l_county per_addresses.region_1%type /*varchar2(30)*/;
552:
553: begin
554: /* Clear the variables, as if no future assignment is made to them,
555: they may hold the previous value assigned

Line 2787: l_addline1 per_addresses.address_line1%TYPE := address_line1;

2783: effective_date in varchar2,
2784: p_assactid in number,
2785: edi_validation_fail out nocopy varchar2) IS
2786:
2787: l_addline1 per_addresses.address_line1%TYPE := address_line1;
2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;
2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;

Line 2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;

2784: p_assactid in number,
2785: edi_validation_fail out nocopy varchar2) IS
2786:
2787: l_addline1 per_addresses.address_line1%TYPE := address_line1;
2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;
2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;

Line 2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;

2785: edi_validation_fail out nocopy varchar2) IS
2786:
2787: l_addline1 per_addresses.address_line1%TYPE := address_line1;
2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;
2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;

Line 2791: l_county per_addresses.region_1%type:= county;

2787: l_addline1 per_addresses.address_line1%TYPE := address_line1;
2788: l_addline2 per_addresses.address_line2%TYPE:= address_line2;
2789: l_addline3 per_addresses.address_line3%TYPE:=address_line3 ;
2790: l_assignment_number per_assignments_f.assignment_number%TYPE:=assignment_number ;
2791: l_county per_addresses.region_1%type:= county;
2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;

Line 2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;

2792: l_first_name per_people_f.first_name%TYPE:= first_name;
2793: l_middle_name per_people_f.middle_names%TYPE:= middle_name;
2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;
2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --
2799: l_effective_date date := effective_date;
2800:

Line 2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --

2794: l_last_name per_people_f.last_name%TYPE:= last_name;
2795: l_ni_number per_people_f.national_identifier%TYPE:= national_insurance_number;
2796: l_postal_code per_addresses.postal_code%TYPE:= postal_code;
2797: l_title per_people_f.title%TYPE:= title ;
2798: l_addline4 per_addresses.town_or_city%TYPE := town_or_city; --
2799: l_effective_date date := effective_date;
2800:
2801: BEGIN
2802:

Line 3146: l_address_line1 per_addresses.address_line1%TYPE;

3142: l_sex per_people_f.sex%TYPE;
3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;

Line 3147: l_address_line2 per_addresses.address_line2%TYPE;

3143: l_ni_number per_people_f.national_identifier%TYPE;
3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;

Line 3148: l_address_line3 per_addresses.address_line3%TYPE;

3144: l_payroll_id per_assignments_f.payroll_id%TYPE;
3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;
3152: l_country per_addresses.country%TYPE;

Line 3149: l_town_or_city per_addresses.town_or_city%TYPE;

3145: --
3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;
3152: l_country per_addresses.country%TYPE;
3153: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 3150: l_county per_addresses.region_1%TYPE;

3146: l_address_line1 per_addresses.address_line1%TYPE;
3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;
3152: l_country per_addresses.country%TYPE;
3153: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3154: l_date_earned DATE;

Line 3151: l_postal_code per_addresses.postal_code%TYPE;

3147: l_address_line2 per_addresses.address_line2%TYPE;
3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;
3152: l_country per_addresses.country%TYPE;
3153: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3154: l_date_earned DATE;
3155: l_eff_date DATE;

Line 3152: l_country per_addresses.country%TYPE;

3148: l_address_line3 per_addresses.address_line3%TYPE;
3149: l_town_or_city per_addresses.town_or_city%TYPE;
3150: l_county per_addresses.region_1%TYPE;
3151: l_postal_code per_addresses.postal_code%TYPE;
3152: l_country per_addresses.country%TYPE;
3153: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3154: l_date_earned DATE;
3155: l_eff_date DATE;
3156: l_last_pay_action_id pay_assignment_actions.payroll_action_id%TYPE;