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_AU_PAYMENT_SUMMARY dependencies on HR_LOCATIONS

Line 42: *** 22 Apr 02 srrajago 1.43 In Cursor employee_detail, hr_locations_all has been replaced by hr_locations (Bug No : 2263587).

38: *** next financial year, then the employee type should
39: *** be current(Bug# 1973978)
40: *** 17 Apr 02 srrajago 1.41 Performance Issue (Bug No : 2263587)
41: *** 17 Apr 02 srrajago 1.42 Included checkfile command
42: *** 22 Apr 02 srrajago 1.43 In Cursor employee_detail, hr_locations_all has been replaced by hr_locations (Bug No : 2263587).
43: *** 06 May 02 vgsriniv 1.44 Cursor get_allowance_balances modified Bug 2359428, 2359423
44: *** 03 Jun 02 Ragovind 1.45 Cursor get_allowance_balances modified for Bug#2398315 to fix the bug 2359428 and to make compatible with both 8i and 9i database versions.
45: *** 15 Jul 02 shoskatt 1.46 For retrieving the ETP Payment values, get the maximum assignment
46: *** action id for which ETP values have been processed (Bug #2459527)

Line 5120: l_etp_address_1 hr_locations.address_line_1%type;

5116:
5117: l_etp_last_name per_all_people_f.last_name%type;
5118: l_etp_first_name per_all_people_f.first_name%type;
5119: l_etp_middle_name per_all_people_f.middle_names%type;
5120: l_etp_address_1 hr_locations.address_line_1%type;
5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;

Line 5121: l_etp_address_2 hr_locations.address_line_2%type;

5117: l_etp_last_name per_all_people_f.last_name%type;
5118: l_etp_first_name per_all_people_f.first_name%type;
5119: l_etp_middle_name per_all_people_f.middle_names%type;
5120: l_etp_address_1 hr_locations.address_line_1%type;
5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;

Line 5122: l_etp_address_3 hr_locations.address_line_3%type;

5118: l_etp_first_name per_all_people_f.first_name%type;
5119: l_etp_middle_name per_all_people_f.middle_names%type;
5120: l_etp_address_1 hr_locations.address_line_1%type;
5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;
5126: l_etp_country fnd_territories_tl.territory_short_name%type;

Line 5123: l_etp_suburb hr_locations.town_or_city%type;

5119: l_etp_middle_name per_all_people_f.middle_names%type;
5120: l_etp_address_1 hr_locations.address_line_1%type;
5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;
5126: l_etp_country fnd_territories_tl.territory_short_name%type;
5127: l_etp_employee_number per_all_people_f.employee_number%type;

Line 5124: l_etp_state hr_locations.region_1%type;

5120: l_etp_address_1 hr_locations.address_line_1%type;
5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;
5126: l_etp_country fnd_territories_tl.territory_short_name%type;
5127: l_etp_employee_number per_all_people_f.employee_number%type;
5128: l_etp_date_of_birth per_all_people_f.date_of_birth%type;

Line 5125: l_etp_postcode hr_locations.postal_code%type;

5121: l_etp_address_2 hr_locations.address_line_2%type;
5122: l_etp_address_3 hr_locations.address_line_3%type;
5123: l_etp_suburb hr_locations.town_or_city%type;
5124: l_etp_state hr_locations.region_1%type;
5125: l_etp_postcode hr_locations.postal_code%type;
5126: l_etp_country fnd_territories_tl.territory_short_name%type;
5127: l_etp_employee_number per_all_people_f.employee_number%type;
5128: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
5129: l_etp_employee_start_date per_periods_of_service.date_start%type;

Line 5131: l_asgmnt_loc hr_locations.location_code%type;

5127: l_etp_employee_number per_all_people_f.employee_number%type;
5128: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
5129: l_etp_employee_start_date per_periods_of_service.date_start%type;
5130: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
5131: l_asgmnt_loc hr_locations.location_code%type;
5132: l_emp_no per_all_people_f.employee_number%type;
5133: l_payroll pay_all_payrolls_f.payroll_name%type;
5134: l_emp_type per_all_people_f.current_employee_flag%type;
5135: l_address_date_from date;

Line 5184: hr_locations_all hlc /* Bug No : 2263587 */

5180: fnd_territories_tl fta,
5181: per_periods_of_service pps,
5182: pay_payroll_actions ppa,
5183: pay_assignment_actions pac,
5184: hr_locations_all hlc /* Bug No : 2263587 */
5185: where hou.business_group_id = c_business_group_id
5186: and hou.organization_id = c_registered_employer
5187: and ppa.action_type = 'X'
5188: and hou.organization_id = hoi.organization_id

Line 6973: l_address_1 hr_locations.address_line_1%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;
6977: l_state hr_locations.region_1%type;

Line 6974: l_address_2 hr_locations.address_line_2%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;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;

Line 6975: l_address_3 hr_locations.address_line_3%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;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;
6979: l_country fnd_territories_tl.territory_short_name%type;

Line 6976: l_suburb hr_locations.town_or_city%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;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;
6979: l_country fnd_territories_tl.territory_short_name%type;
6980: l_signatory hr_organization_information.org_information8%type;

Line 6977: l_state hr_locations.region_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;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;
6979: l_country fnd_territories_tl.territory_short_name%type;
6980: l_signatory hr_organization_information.org_information8%type;
6981: e_employer_nf EXCEPTION;

Line 6978: l_postcode hr_locations.postal_code%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;
6977: l_state hr_locations.region_1%type;
6978: l_postcode hr_locations.postal_code%type;
6979: l_country fnd_territories_tl.territory_short_name%type;
6980: l_signatory hr_organization_information.org_information8%type;
6981: e_employer_nf EXCEPTION;
6982:

Line 7009: ,hr_locations hlc

7005: ,hlc.region_1 state
7006: ,hlc.postal_code postcode
7007: ,ftl.territory_short_name country
7008: from hr_organization_information hoi
7009: ,hr_locations hlc
7010: ,fnd_territories_tl ftl
7011: ,hr_organization_units hou
7012: ,per_all_people_f papcont
7013: ,per_all_people_f papsign

Line 7194: l_address_1 hr_locations.address_line_1%type;

7190: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;
7191: l_first_name per_all_people_f.first_name%type;
7192: l_middle_name per_all_people_f.middle_names%type;
7193: l_surname per_all_people_f.last_name%type;
7194: l_address_1 hr_locations.address_line_1%type;
7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;

Line 7195: l_address_2 hr_locations.address_line_2%type;

7191: l_first_name per_all_people_f.first_name%type;
7192: l_middle_name per_all_people_f.middle_names%type;
7193: l_surname per_all_people_f.last_name%type;
7194: l_address_1 hr_locations.address_line_1%type;
7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;

Line 7196: l_address_3 hr_locations.address_line_3%type;

7192: l_middle_name per_all_people_f.middle_names%type;
7193: l_surname per_all_people_f.last_name%type;
7194: l_address_1 hr_locations.address_line_1%type;
7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;
7200: l_country fnd_territories_tl.territory_short_name%type;

Line 7197: l_suburb hr_locations.town_or_city%type;

7193: l_surname per_all_people_f.last_name%type;
7194: l_address_1 hr_locations.address_line_1%type;
7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;
7200: l_country fnd_territories_tl.territory_short_name%type;
7201: l_start_date VARCHAR2(20);

Line 7198: l_state hr_locations.region_1%type;

7194: l_address_1 hr_locations.address_line_1%type;
7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;
7200: l_country fnd_territories_tl.territory_short_name%type;
7201: l_start_date VARCHAR2(20);
7202: l_termination_date VARCHAR2(20);

Line 7199: l_postcode hr_locations.postal_code%type;

7195: l_address_2 hr_locations.address_line_2%type;
7196: l_address_3 hr_locations.address_line_3%type;
7197: l_suburb hr_locations.town_or_city%type;
7198: l_state hr_locations.region_1%type;
7199: l_postcode hr_locations.postal_code%type;
7200: l_country fnd_territories_tl.territory_short_name%type;
7201: l_start_date VARCHAR2(20);
7202: l_termination_date VARCHAR2(20);
7203: l_dob VARCHAR2(20);

Line 7204: l_asgmnt_loc hr_locations.location_code%type;

7200: l_country fnd_territories_tl.territory_short_name%type;
7201: l_start_date VARCHAR2(20);
7202: l_termination_date VARCHAR2(20);
7203: l_dob VARCHAR2(20);
7204: l_asgmnt_loc hr_locations.location_code%type;
7205: l_emp_no per_all_people_f.employee_number%type;
7206: l_payroll pay_all_payrolls_f.payroll_name%type;
7207: l_emp_type per_all_people_f.current_employee_flag%type;
7208: l_address_date_from date;

Line 7312: hr_locations hlc, /* Bug No : 2263587 */

7308: ,pps.pds_information1 termination_type --Bug 8315198
7309: from hr_organization_information hoi,
7310: hr_organization_units hou,
7311: hr_soft_coding_keyflex hsc,
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,

Line 7737: l_supplier_address_1 hr_locations.address_line_1%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;
7741: l_supplier_state hr_locations.region_1%type;

Line 7738: l_supplier_address_2 hr_locations.address_line_2%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;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;

Line 7739: l_supplier_address_3 hr_locations.address_line_3%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;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;
7743: l_supplier_country fnd_territories_tl.territory_short_name%type;

Line 7740: l_supplier_suburb hr_locations.town_or_city%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;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;
7743: l_supplier_country fnd_territories_tl.territory_short_name%type;
7744:

Line 7741: l_supplier_state hr_locations.region_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;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;
7743: l_supplier_country fnd_territories_tl.territory_short_name%type;
7744:
7745: ------------------------------------------------------------------------------+

Line 7742: l_supplier_postcode hr_locations.postal_code%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;
7741: l_supplier_state hr_locations.region_1%type;
7742: l_supplier_postcode hr_locations.postal_code%type;
7743: l_supplier_country fnd_territories_tl.territory_short_name%type;
7744:
7745: ------------------------------------------------------------------------------+
7746: -- cursor to get supplier details

Line 7767: ,hr_locations hrl

7763: ,ftl.territory_short_name supplier_country
7764: ,pap.email_address email_address
7765: from hr_organization_information hoi
7766: ,hr_organization_units hou
7767: ,hr_locations hrl
7768: ,fnd_territories_tl ftl
7769: ,per_all_people_f pap
7770: where hou.business_group_id = p_business_group_id
7771: and hou.organization_id = p_registered_employer