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 2842: l_etp_address_1 hr_locations.address_line_1%type;

2838:
2839: l_etp_last_name per_all_people_f.last_name%type;
2840: l_etp_first_name per_all_people_f.first_name%type;
2841: l_etp_middle_name per_all_people_f.middle_names%type;
2842: l_etp_address_1 hr_locations.address_line_1%type;
2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;

Line 2843: l_etp_address_2 hr_locations.address_line_2%type;

2839: l_etp_last_name per_all_people_f.last_name%type;
2840: l_etp_first_name per_all_people_f.first_name%type;
2841: l_etp_middle_name per_all_people_f.middle_names%type;
2842: l_etp_address_1 hr_locations.address_line_1%type;
2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;

Line 2844: l_etp_address_3 hr_locations.address_line_3%type;

2840: l_etp_first_name per_all_people_f.first_name%type;
2841: l_etp_middle_name per_all_people_f.middle_names%type;
2842: l_etp_address_1 hr_locations.address_line_1%type;
2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;

Line 2845: l_etp_suburb hr_locations.town_or_city%type;

2841: l_etp_middle_name per_all_people_f.middle_names%type;
2842: l_etp_address_1 hr_locations.address_line_1%type;
2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;

Line 2846: l_etp_state hr_locations.region_1%type;

2842: l_etp_address_1 hr_locations.address_line_1%type;
2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;

Line 2847: l_etp_postcode hr_locations.postal_code%type;

2843: l_etp_address_2 hr_locations.address_line_2%type;
2844: l_etp_address_3 hr_locations.address_line_3%type;
2845: l_etp_suburb hr_locations.town_or_city%type;
2846: l_etp_state hr_locations.region_1%type;
2847: l_etp_postcode hr_locations.postal_code%type;
2848: l_etp_country fnd_territories_tl.territory_short_name%type;
2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
2851: l_etp_employee_start_date per_periods_of_service.date_start%type;

Line 2853: l_asgmnt_loc hr_locations.location_code%type;

2849: l_etp_employee_number per_all_people_f.employee_number%type;
2850: l_etp_date_of_birth per_all_people_f.date_of_birth%type;
2851: l_etp_employee_start_date per_periods_of_service.date_start%type;
2852: l_etp_death_benefit per_periods_of_service.leaving_reason%type;
2853: l_asgmnt_loc hr_locations.location_code%type;
2854: l_emp_no per_all_people_f.employee_number%type;
2855: l_payroll pay_all_payrolls_f.payroll_name%type;
2856: l_emp_type per_all_people_f.current_employee_flag%type;
2857: l_address_date_from date;

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

2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,
2904: hr_locations_all hlc /* Bug No : 2263587 */
2905: where hou.business_group_id = c_business_group_id
2906: and hou.organization_id = c_registered_employer
2907: and ppa.action_type = 'X'
2908: and hou.organization_id = hoi.organization_id

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

Line 3531: l_address_2 hr_locations.address_line_2%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;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;

Line 3532: l_address_3 hr_locations.address_line_3%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;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;
3536: l_country fnd_territories_tl.territory_short_name%type;

Line 3533: l_suburb hr_locations.town_or_city%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;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;
3536: l_country fnd_territories_tl.territory_short_name%type;
3537: l_signatory hr_organization_information.org_information8%type;

Line 3534: l_state hr_locations.region_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;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;
3536: l_country fnd_territories_tl.territory_short_name%type;
3537: l_signatory hr_organization_information.org_information8%type;
3538: e_employer_nf EXCEPTION;

Line 3535: l_postcode hr_locations.postal_code%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;
3534: l_state hr_locations.region_1%type;
3535: l_postcode hr_locations.postal_code%type;
3536: l_country fnd_territories_tl.territory_short_name%type;
3537: l_signatory hr_organization_information.org_information8%type;
3538: e_employer_nf EXCEPTION;
3539:

Line 3566: ,hr_locations hlc

3562: ,hlc.region_1 state
3563: ,hlc.postal_code postcode
3564: ,ftl.territory_short_name country
3565: from hr_organization_information hoi
3566: ,hr_locations hlc
3567: ,fnd_territories_tl ftl
3568: ,hr_organization_units hou
3569: ,per_all_people_f papcont
3570: ,per_all_people_f papsign

Line 3751: l_address_1 hr_locations.address_line_1%type;

3747: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;
3748: l_first_name per_all_people_f.first_name%type;
3749: l_middle_name per_all_people_f.middle_names%type;
3750: l_surname per_all_people_f.last_name%type;
3751: l_address_1 hr_locations.address_line_1%type;
3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;

Line 3752: l_address_2 hr_locations.address_line_2%type;

3748: l_first_name per_all_people_f.first_name%type;
3749: l_middle_name per_all_people_f.middle_names%type;
3750: l_surname per_all_people_f.last_name%type;
3751: l_address_1 hr_locations.address_line_1%type;
3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;

Line 3753: l_address_3 hr_locations.address_line_3%type;

3749: l_middle_name per_all_people_f.middle_names%type;
3750: l_surname per_all_people_f.last_name%type;
3751: l_address_1 hr_locations.address_line_1%type;
3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;
3757: l_country fnd_territories_tl.territory_short_name%type;

Line 3754: l_suburb hr_locations.town_or_city%type;

3750: l_surname per_all_people_f.last_name%type;
3751: l_address_1 hr_locations.address_line_1%type;
3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;
3757: l_country fnd_territories_tl.territory_short_name%type;
3758: l_start_date VARCHAR2(20);

Line 3755: l_state hr_locations.region_1%type;

3751: l_address_1 hr_locations.address_line_1%type;
3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;
3757: l_country fnd_territories_tl.territory_short_name%type;
3758: l_start_date VARCHAR2(20);
3759: l_termination_date VARCHAR2(20);

Line 3756: l_postcode hr_locations.postal_code%type;

3752: l_address_2 hr_locations.address_line_2%type;
3753: l_address_3 hr_locations.address_line_3%type;
3754: l_suburb hr_locations.town_or_city%type;
3755: l_state hr_locations.region_1%type;
3756: l_postcode hr_locations.postal_code%type;
3757: l_country fnd_territories_tl.territory_short_name%type;
3758: l_start_date VARCHAR2(20);
3759: l_termination_date VARCHAR2(20);
3760: l_dob VARCHAR2(20);

Line 3761: l_asgmnt_loc hr_locations.location_code%type;

3757: l_country fnd_territories_tl.territory_short_name%type;
3758: l_start_date VARCHAR2(20);
3759: l_termination_date VARCHAR2(20);
3760: l_dob VARCHAR2(20);
3761: l_asgmnt_loc hr_locations.location_code%type;
3762: l_emp_no per_all_people_f.employee_number%type;
3763: l_payroll pay_all_payrolls_f.payroll_name%type;
3764: l_emp_type per_all_people_f.current_employee_flag%type;
3765: l_address_date_from date;

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

3863: ,to_char(paa.effective_end_date,'DDMMYYYY') -- Bug 2610141
3864: from hr_organization_information hoi,
3865: hr_organization_units hou,
3866: hr_soft_coding_keyflex hsc,
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,

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

Line 4276: l_supplier_address_2 hr_locations.address_line_2%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;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;

Line 4277: l_supplier_address_3 hr_locations.address_line_3%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;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;
4281: l_supplier_country fnd_territories_tl.territory_short_name%type;

Line 4278: l_supplier_suburb hr_locations.town_or_city%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;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;
4281: l_supplier_country fnd_territories_tl.territory_short_name%type;
4282:

Line 4279: l_supplier_state hr_locations.region_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;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;
4281: l_supplier_country fnd_territories_tl.territory_short_name%type;
4282:
4283: ------------------------------------------------------------------------------+

Line 4280: l_supplier_postcode hr_locations.postal_code%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;
4279: l_supplier_state hr_locations.region_1%type;
4280: l_supplier_postcode hr_locations.postal_code%type;
4281: l_supplier_country fnd_territories_tl.territory_short_name%type;
4282:
4283: ------------------------------------------------------------------------------+
4284: -- cursor to get supplier details

Line 4305: ,hr_locations hrl

4301: ,ftl.territory_short_name supplier_country
4302: ,pap.email_address email_address
4303: from hr_organization_information hoi
4304: ,hr_organization_units hou
4305: ,hr_locations hrl
4306: ,fnd_territories_tl ftl
4307: ,per_all_people_f pap
4308: where hou.business_group_id = p_business_group_id
4309: and hou.organization_id = p_registered_employer