APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PER_ADDRESSES

Line 2899: per_addresses pad,

2895: pay_element_entries_f pee,
2896: pay_element_entry_values_f pev,
2897: per_all_assignments_f paa,
2898: per_all_people_f pap,
2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,

Line 3529: l_tel_number per_addresses.telephone_number_1%type;

3525: l_trading_name hr_organization_information.org_information4%type;
3526: l_abn hr_organization_information.org_information12%type;
3527: l_branch_number hr_organization_information.org_information13%type;
3528: l_contact_name hr_organization_information.org_information7%type;
3529: l_tel_number per_addresses.telephone_number_1%type;
3530: l_address_1 hr_locations.address_line_1%type;
3531: l_address_2 hr_locations.address_line_2%type;
3532: l_address_3 hr_locations.address_line_3%type;
3533: l_suburb hr_locations.town_or_city%type;

Line 3774: l_address_style per_addresses.style%type; -- Bug 5364017

3770: l_fpd_archive VARCHAR2(20); -- Bug3098353
3771: l_le_start_date VARCHAR2(20);
3772: l_le_end_date VARCHAR2(20); -- Bug 2610141
3773:
3774: l_address_style per_addresses.style%type; -- Bug 5364017
3775: l_add_country per_addresses.country%type; -- Bug 5364017
3776:
3777: e_employee_nf EXCEPTION;
3778:

Line 3775: l_add_country per_addresses.country%type; -- Bug 5364017

3771: l_le_start_date VARCHAR2(20);
3772: l_le_end_date VARCHAR2(20); -- Bug 2610141
3773:
3774: l_address_style per_addresses.style%type; -- Bug 5364017
3775: l_add_country per_addresses.country%type; -- Bug 5364017
3776:
3777: e_employee_nf EXCEPTION;
3778:
3779: l_le_etp_service_date varchar2(20); /* Bug 4177679 */

Line 3790: per_addresses table for the same primary address;the previous address is end dated.

3786: /* Bug 1973978 -- If the Termination date of the employee is greater than the last date of the current financial
3787: year then the employee should be treated as an Current Employee */
3788: /* Bug 2512431 -- Removed to_date for p_year_end in the select statement for emp_type */
3789: /* Bug 2977533 - When a new address is created thro SS applications ,2 rows are created in
3790: per_addresses table for the same primary address;the previous address is end dated.
3791: This can also be simulated thro apps if a primary addresses is end dated and a new
3792: primary address is created after the end date
3793: The cursor fetches 2 rows and picks the old address first.To get the latest address
3794: order by clause has been added to pick the latest row first */

Line 3871: per_addresses pad,

3867: hr_locations hlc, /* Bug No : 2263587 */
3868: per_all_assignments_f paa,
3869: per_all_assignments_f paaf, /* Bug : 2610141 */
3870: per_all_people_f pap,
3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,

Line 4274: l_supplier_contact_phone per_addresses.telephone_number_1%type;

4270: l_supplier_number hr_organization_information.org_information1%type;
4271: l_supplier_name hr_organization_information.org_information3%type;
4272: l_supplier_abn hr_organization_information.org_information5%type;
4273: l_supplier_contact_name per_all_people_f.full_name%type;
4274: l_supplier_contact_phone per_addresses.telephone_number_1%type;
4275: l_supplier_address_1 hr_locations.address_line_1%type;
4276: l_supplier_address_2 hr_locations.address_line_2%type;
4277: l_supplier_address_3 hr_locations.address_line_3%type;
4278: l_supplier_suburb hr_locations.town_or_city%type;