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 489: from per_addresses addr

485: addr.TOWN_OR_CITY,
486: addr.REGION_1,
487: addr.COUNTRY,
488: addr.POSTAL_CODE
489: from per_addresses addr
490: where addr.PERSON_ID = X_PERSON_ID
491: and addr.PRIMARY_FLAG = 'Y'
492: and X_SESSION_DATE between
493: addr.DATE_FROM and

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

499: where ftv.territory_code = p_code;
500:
501: l_addr c_addr%rowtype;
502: l_found boolean;
503: l_county per_addresses.region_1%type /*varchar2(30)*/;
504:
505: begin
506: /* Clear the variables, as if no future assignment is made to them,
507: they may hold the previous value assigned

Line 2790: l_address_line1 per_addresses.address_line1%TYPE;

2786: l_sex per_people_f.sex%TYPE;
2787: l_ni_number per_people_f.national_identifier%TYPE;
2788: l_payroll_id per_assignments_f.payroll_id%TYPE;
2789: --
2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;

Line 2791: l_address_line2 per_addresses.address_line2%TYPE;

2787: l_ni_number per_people_f.national_identifier%TYPE;
2788: l_payroll_id per_assignments_f.payroll_id%TYPE;
2789: --
2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;

Line 2792: l_address_line3 per_addresses.address_line3%TYPE;

2788: l_payroll_id per_assignments_f.payroll_id%TYPE;
2789: --
2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;
2796: l_country per_addresses.country%TYPE;

Line 2793: l_town_or_city per_addresses.town_or_city%TYPE;

2789: --
2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;
2796: l_country per_addresses.country%TYPE;
2797: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2794: l_county per_addresses.region_1%TYPE;

2790: l_address_line1 per_addresses.address_line1%TYPE;
2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;
2796: l_country per_addresses.country%TYPE;
2797: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
2798: l_date_earned DATE;

Line 2795: l_postal_code per_addresses.postal_code%TYPE;

2791: l_address_line2 per_addresses.address_line2%TYPE;
2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;
2796: l_country per_addresses.country%TYPE;
2797: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
2798: l_date_earned DATE;
2799: l_eff_date DATE;

Line 2796: l_country per_addresses.country%TYPE;

2792: l_address_line3 per_addresses.address_line3%TYPE;
2793: l_town_or_city per_addresses.town_or_city%TYPE;
2794: l_county per_addresses.region_1%TYPE;
2795: l_postal_code per_addresses.postal_code%TYPE;
2796: l_country per_addresses.country%TYPE;
2797: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
2798: l_date_earned DATE;
2799: l_eff_date DATE;
2800: l_last_pay_action_id pay_assignment_actions.payroll_action_id%TYPE;