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 5169: from hr_organization_information hoi,

5165: ,nvl(to_char(pps.actual_termination_date,'DDMMYYYY'),'31124712') employee_termination_date
5166: ,decode(pps.pds_information1, 'AU_D','Y', 'N') death_benefit/*bug#1955993*/
5167: ,pad.date_from date_from/*Bug 2977533 */
5168: ,decode(pps.pds_information1, 'AU_D',nvl(pps.pds_information11,'000 000 000'),pev.screen_entry_value) etp_death_benefit_tfn /*Bug#8315198*/
5169: from hr_organization_information hoi,
5170: hr_organization_units hou,
5171: hr_soft_coding_keyflex hsc,
5172: pay_element_types_f pet,
5173: pay_input_values_f piv,

Line 6966: l_group_act_no hr_organization_information.org_information1%type;

6962: p_year_end in pay_payroll_Actions.effective_date%type) is
6963:
6964:
6965:
6966: l_group_act_no hr_organization_information.org_information1%type;
6967: l_business_name hr_organization_information.org_information3%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;

Line 6967: l_business_name hr_organization_information.org_information3%type;

6963:
6964:
6965:
6966: l_group_act_no hr_organization_information.org_information1%type;
6967: l_business_name hr_organization_information.org_information3%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;

Line 6968: l_trading_name hr_organization_information.org_information4%type;

6964:
6965:
6966: l_group_act_no hr_organization_information.org_information1%type;
6967: l_business_name hr_organization_information.org_information3%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;

Line 6969: l_abn hr_organization_information.org_information12%type;

6965:
6966: l_group_act_no hr_organization_information.org_information1%type;
6967: l_business_name hr_organization_information.org_information3%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;

Line 6970: l_branch_number hr_organization_information.org_information13%type;

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

Line 6971: l_contact_name hr_organization_information.org_information7%type;

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

Line 6980: l_signatory hr_organization_information.org_information8%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:
6983:
6984: ---------------------------------------------------------------------------------+

Line 7008: from hr_organization_information hoi

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

Line 7309: from hr_organization_information hoi,

7305: ,pps.actual_termination_date
7306: ,to_char(paaf.effective_start_date,'DDMMYYYY')
7307: ,to_char(paa.effective_end_date,'DDMMYYYY') -- Bug 2610141
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,

Line 7732: l_supplier_number hr_organization_information.org_information1%type;

7728: p_year_end in pay_payroll_Actions.effective_date%type) is
7729:
7730:
7731: l_report_end_date varchar2(20);
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;

Line 7733: l_supplier_name hr_organization_information.org_information3%type;

7729:
7730:
7731: l_report_end_date varchar2(20);
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;

Line 7734: l_supplier_abn hr_organization_information.org_information5%type;

7730:
7731: l_report_end_date varchar2(20);
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;

Line 7765: from hr_organization_information hoi

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