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

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

574: SELECT effective_date
575: FROM pay_payroll_actions
576: WHERE payroll_action_id = pactid;
577:
578: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
579: ,c_bg_id hr_organization_units.business_group_id%type) IS
580: select hou.organization_id org_id
581: ,hou.name employer_name
582: ,hla.address_line_1 addr1

Line 592: ,hr_organization_information hoi

588: ,flv.meaning County
589: ,hla.COUNTRY Country_Name
590: ,hla.REGION_1
591: from hr_organization_units hou
592: ,hr_organization_information hoi
593: ,hr_locations_all hla
594: ,fnd_lookup_values flv
595: where hoi.org_information_context='IE_EMPLOYER_INFO'
596: and hoi.organization_id=c_org_id

Line 605: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type

601: and flv.language(+) = 'US'
602: and flv.lookup_code(+) = hla.REGION_1;
603:
604:
605: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type
606: ,c_bg_id hr_organization_units.business_group_id%type
607: ,p_year varchar2
608: ,p_qtr varchar2) IS
609: select hoi.org_information3 cbr_no

Line 615: ,hr_organization_information hoi

611: ,hoi.org_information17 position
612: ,hoi.org_information19 email
613: ,hoi.org_information20 phone
614: from hr_organization_units hou
615: ,hr_organization_information hoi
616: where hoi.org_information_context='IE_EHECS'
617: and hoi.organization_id=c_org_id
618: and hoi.organization_id=hou.organization_id
619: and hou.business_group_id= c_bg_id

Line 642: l_cbr_no hr_organization_information.org_information3%type;

638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;

Line 643: l_person_id hr_organization_information.org_information13%type;

639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;
646: l_declarant_email_add per_all_people_f.email_address%type;
647: l_declarant_position per_all_positions.name%type;

Line 1246: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type

1242: AND scl.segment4 = to_char(g_employer_id)
1243: AND to_char(ppa.effective_date,'yyyy')=to_char(g_year); -- 9734490
1244:
1245:
1246: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
1247: ,c_bg_id hr_organization_units.business_group_id%type
1248: ) IS
1249: select hoi.org_information18 hrs_per_day
1250: from hr_organization_units hou

Line 1251: ,hr_organization_information hoi

1247: ,c_bg_id hr_organization_units.business_group_id%type
1248: ) IS
1249: select hoi.org_information18 hrs_per_day
1250: from hr_organization_units hou
1251: ,hr_organization_information hoi
1252: where hoi.org_information_context='IE_EHECS'
1253: and hoi.organization_id=c_org_id
1254: and hoi.organization_id=hou.organization_id
1255: and hou.business_group_id= c_bg_id;