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_IE_P45PART3_P46_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 227: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type

223: SELECT effective_date
224: FROM pay_payroll_actions
225: WHERE payroll_action_id = pactid;
226:
227: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
228: ,c_bg_id hr_organization_units.business_group_id%type) IS
229: select hoi.org_information2 regst_no
230: ,hou.name employer_name
231: ,hoi.org_information3 trade_name

Line 239: ,hr_organization_information hoi

235: ,hoi.org_information4 contact_name
236: ,hla.telephone_number_1 telphone_no
237: ,hla.telephone_number_2 fax
238: from hr_organization_units hou
239: ,hr_organization_information hoi
240: ,hr_locations_all hla
241: where hoi.org_information_context='IE_EMPLOYER_INFO'
242: and hoi.organization_id=c_org_id
243: and hoi.organization_id=hou.organization_id

Line 250: l_regst_no hr_organization_information.org_information2%type;

246:
247: l_employer_details csr_employer_details%rowtype;
248: l_action_info_id NUMBER;
249: l_ovn NUMBER;
250: l_regst_no hr_organization_information.org_information2%type;
251: l_trade_name hr_organization_information.org_information3%type;
252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;

Line 251: l_trade_name hr_organization_information.org_information3%type;

247: l_employer_details csr_employer_details%rowtype;
248: l_action_info_id NUMBER;
249: l_ovn NUMBER;
250: l_regst_no hr_organization_information.org_information2%type;
251: l_trade_name hr_organization_information.org_information3%type;
252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;

Line 256: l_contact_name hr_organization_information.org_information4%type;

252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;
258: l_fax_no hr_locations_all.telephone_number_2%type;
259:
260: BEGIN

Line 691: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type

687: FROM pay_payroll_actions
688: WHERE payroll_action_id = pactid;
689:
690: /*
691: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
692: ,c_bg_id hr_organization_units.business_group_id%type) IS
693: select hoi.org_information2 regst_no
694: ,hou.name employer_name
695: ,hoi.org_information3 trade_name

Line 703: ,hr_organization_information hoi

699: ,hoi.org_information4 contact_name
700: ,hla.telephone_number_1 telphone_no
701: ,hla.telephone_number_2 fax
702: from hr_organization_units hou
703: ,hr_organization_information hoi
704: ,hr_locations_all hla
705: where hoi.org_information_context='IE_EMPLOYER_INFO'
706: and hoi.organization_id=c_org_id
707: and hoi.organization_id=hou.organization_id

Line 714: l_regst_no hr_organization_information.org_information2%type;

710:
711: l_employer_details csr_employer_details%rowtype;
712: l_action_info_id NUMBER;
713: l_ovn NUMBER;
714: l_regst_no hr_organization_information.org_information2%type;
715: l_trade_name hr_organization_information.org_information3%type;
716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;

Line 715: l_trade_name hr_organization_information.org_information3%type;

711: l_employer_details csr_employer_details%rowtype;
712: l_action_info_id NUMBER;
713: l_ovn NUMBER;
714: l_regst_no hr_organization_information.org_information2%type;
715: l_trade_name hr_organization_information.org_information3%type;
716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;

Line 720: l_contact_name hr_organization_information.org_information4%type;

716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;
723: */
724: BEGIN