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 230: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type

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

Line 242: ,hr_organization_information hoi

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

Line 253: l_regst_no hr_organization_information.org_information2%type;

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

Line 254: l_trade_name hr_organization_information.org_information3%type;

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

Line 259: l_contact_name hr_organization_information.org_information4%type;

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

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

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

Line 706: ,hr_organization_information hoi

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

Line 717: l_regst_no hr_organization_information.org_information2%type;

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

Line 718: l_trade_name hr_organization_information.org_information3%type;

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

Line 723: l_contact_name hr_organization_information.org_information4%type;

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