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_ORGANIZATION_INFORMATION

Line 2889: from hr_organization_information hoi,

2885: ,pps.pds_information2 death_benefit_type
2886: ,nvl(to_char(pps.actual_termination_date,'DDMMYYYY'),'31124712') employee_termination_date
2887: ,decode(pps.pds_information1, 'AU_D','Y', 'N') death_benefit/*bug#1955993*/
2888: ,pad.date_from date_from/*Bug 2977533 */
2889: from hr_organization_information hoi,
2890: hr_organization_units hou,
2891: hr_soft_coding_keyflex hsc,
2892: pay_element_types_f pet,
2893: pay_input_values_f piv,

Line 3523: l_group_act_no hr_organization_information.org_information1%type;

3519: p_year_end in pay_payroll_Actions.effective_date%type) is
3520:
3521:
3522:
3523: l_group_act_no hr_organization_information.org_information1%type;
3524: l_business_name hr_organization_information.org_information3%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;

Line 3524: l_business_name hr_organization_information.org_information3%type;

3520:
3521:
3522:
3523: l_group_act_no hr_organization_information.org_information1%type;
3524: l_business_name hr_organization_information.org_information3%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;

Line 3525: l_trading_name hr_organization_information.org_information4%type;

3521:
3522:
3523: l_group_act_no hr_organization_information.org_information1%type;
3524: l_business_name hr_organization_information.org_information3%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;

Line 3526: l_abn hr_organization_information.org_information12%type;

3522:
3523: l_group_act_no hr_organization_information.org_information1%type;
3524: l_business_name hr_organization_information.org_information3%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;

Line 3527: l_branch_number hr_organization_information.org_information13%type;

3523: l_group_act_no hr_organization_information.org_information1%type;
3524: l_business_name hr_organization_information.org_information3%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;

Line 3528: l_contact_name hr_organization_information.org_information7%type;

3524: l_business_name hr_organization_information.org_information3%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;

Line 3537: l_signatory hr_organization_information.org_information8%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:
3540:
3541: ---------------------------------------------------------------------------------+

Line 3565: from hr_organization_information hoi

3561: ,hlc.town_or_city suburb
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

Line 3864: from hr_organization_information hoi,

3860: ,ppa1.effective_date -- Bug3263659
3861: ,pps.actual_termination_date
3862: ,to_char(paaf.effective_start_date,'DDMMYYYY')
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,

Line 4270: l_supplier_number hr_organization_information.org_information1%type;

4266: p_year_end in pay_payroll_Actions.effective_date%type) is
4267:
4268:
4269: l_report_end_date varchar2(20);
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;

Line 4271: l_supplier_name hr_organization_information.org_information3%type;

4267:
4268:
4269: l_report_end_date varchar2(20);
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;

Line 4272: l_supplier_abn hr_organization_information.org_information5%type;

4268:
4269: l_report_end_date varchar2(20);
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;

Line 4303: from hr_organization_information hoi

4299: ,hrl.region_1 supplier_state
4300: ,hrl.postal_code supplier_postcode
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