APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PER_ADDRESSES

Line 5179: per_addresses pad,

5175: pay_element_entries_f pee,
5176: pay_element_entry_values_f pev,
5177: per_all_assignments_f paa,
5178: per_all_people_f pap,
5179: per_addresses pad,
5180: fnd_territories_tl fta,
5181: per_periods_of_service pps,
5182: pay_payroll_actions ppa,
5183: pay_assignment_actions pac,

Line 6972: l_tel_number per_addresses.telephone_number_1%type;

6968: l_trading_name hr_organization_information.org_information4%type;
6969: l_abn hr_organization_information.org_information12%type;
6970: l_branch_number hr_organization_information.org_information13%type;
6971: l_contact_name hr_organization_information.org_information7%type;
6972: l_tel_number per_addresses.telephone_number_1%type;
6973: l_address_1 hr_locations.address_line_1%type;
6974: l_address_2 hr_locations.address_line_2%type;
6975: l_address_3 hr_locations.address_line_3%type;
6976: l_suburb hr_locations.town_or_city%type;

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

7214: l_le_start_date VARCHAR2(20);
7215: l_le_end_date VARCHAR2(20); -- Bug 2610141
7216: l_termination_type VARCHAR2(4); -- Bug 8315198
7217:
7218: l_address_style per_addresses.style%type; -- Bug 5364017
7219: l_add_country per_addresses.country%type; -- Bug 5364017
7220:
7221: e_employee_nf EXCEPTION;
7222:

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

7215: l_le_end_date VARCHAR2(20); -- Bug 2610141
7216: l_termination_type VARCHAR2(4); -- Bug 8315198
7217:
7218: l_address_style per_addresses.style%type; -- Bug 5364017
7219: l_add_country per_addresses.country%type; -- Bug 5364017
7220:
7221: e_employee_nf EXCEPTION;
7222:
7223: l_le_etp_service_date varchar2(20); /* Bug 4177679 */

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

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

Line 7316: per_addresses pad,

7312: hr_locations hlc, /* Bug No : 2263587 */
7313: per_all_assignments_f paa,
7314: per_all_assignments_f paaf, /* Bug : 2610141 */
7315: per_all_people_f pap,
7316: per_addresses pad,
7317: fnd_territories_tl fta,
7318: per_periods_of_service pps,
7319: pay_payroll_actions ppa,
7320: pay_assignment_actions pac,

Line 7736: l_supplier_contact_phone per_addresses.telephone_number_1%type;

7732: l_supplier_number hr_organization_information.org_information1%type;
7733: l_supplier_name hr_organization_information.org_information3%type;
7734: l_supplier_abn hr_organization_information.org_information5%type;
7735: l_supplier_contact_name per_all_people_f.full_name%type;
7736: l_supplier_contact_phone per_addresses.telephone_number_1%type;
7737: l_supplier_address_1 hr_locations.address_line_1%type;
7738: l_supplier_address_2 hr_locations.address_line_2%type;
7739: l_supplier_address_3 hr_locations.address_line_3%type;
7740: l_supplier_suburb hr_locations.town_or_city%type;