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

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

463: SELECT effective_date
464: FROM pay_payroll_actions
465: WHERE payroll_action_id = pactid;
466:
467: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
468: ,c_bg_id hr_organization_units.business_group_id%type) IS
469: select hou.organization_id org_id
470: ,hou.name employer_name
471: ,hla.address_line_1 addr1

Line 475: ,hr_organization_information hoi

471: ,hla.address_line_1 addr1
472: ,hla.address_line_2 addr2
473: ,hla.address_line_3 addr3
474: from hr_organization_units hou
475: ,hr_organization_information hoi
476: ,hr_locations_all hla
477: where hoi.org_information_context='IE_EMPLOYER_INFO'
478: and hoi.organization_id=c_org_id
479: and hoi.organization_id=hou.organization_id

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

480: and hou.business_group_id= c_bg_id
481: and hou.location_id=hla.location_id(+);
482:
483:
484: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type
485: ,c_bg_id hr_organization_units.business_group_id%type
486: ,p_year varchar2
487: ,p_qtr varchar2) IS
488: select hoi.org_information3 cbr_no

Line 494: ,hr_organization_information hoi

490: ,hoi.org_information17 position -- bug 6850742
491: ,hoi.org_information19 email -- bug 6850742
492: ,hoi.org_information20 phone -- bug 6850742
493: from hr_organization_units hou
494: ,hr_organization_information hoi
495: where hoi.org_information_context='IE_EHECS'
496: and hoi.organization_id=c_org_id
497: and hoi.organization_id=hou.organization_id
498: and hou.business_group_id= c_bg_id

Line 538: l_cbr_no hr_organization_information.org_information3%type;

534: l_addr2 hr_locations_all.address_line_2%type;
535: l_addr3 hr_locations_all.address_line_3%type;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;

Line 539: l_person_id hr_organization_information.org_information13%type;

535: l_addr3 hr_locations_all.address_line_3%type;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;
542: l_declarant_email_add per_all_people_f.email_address%type;
543: l_declarant_position per_all_positions.name%type;

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

993:
994: l_valid_asg_act_rec cur_valid_asg_act%ROWTYPE;
995:
996: /*6856473 added the cursor and the variables */
997: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
998: ,c_bg_id hr_organization_units.business_group_id%type
999: ) IS
1000: select hoi.org_information18 hrs_per_day
1001: from hr_organization_units hou

Line 1002: ,hr_organization_information hoi

998: ,c_bg_id hr_organization_units.business_group_id%type
999: ) IS
1000: select hoi.org_information18 hrs_per_day
1001: from hr_organization_units hou
1002: ,hr_organization_information hoi
1003: where hoi.org_information_context='IE_EHECS'
1004: and hoi.organization_id=c_org_id
1005: and hoi.organization_id=hou.organization_id
1006: and hou.business_group_id= c_bg_id;

Line 2112: ,hr_organization_information hoi

2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou
2112: ,hr_organization_information hoi
2113: where hoi.org_information_context='IE_EHECS_OVERRIDE'
2114: and hoi.organization_id=c_org_id
2115: and hoi.organization_id=hou.organization_id
2116: and hou.business_group_id= c_bg_id

Line 2338: CURSOR csr_ehecs_eit(c_org_id hr_organization_information.organization_id%type

2334: --l_asg_action_id NUMBER;
2335: l_action_info_id NUMBER;
2336: l_ovn NUMBER;
2337:
2338: CURSOR csr_ehecs_eit(c_org_id hr_organization_information.organization_id%type
2339: ,c_bg_id hr_organization_units.business_group_id%type
2340: ,p_year VARCHAR2
2341: ,p_qtr VARCHAR2) IS
2342: select hoi.org_information1 Year,

Line 2359: ,hr_organization_information hoi

2355: hoi.org_information14 Trng_subsidy,
2356: hoi.org_information15 otr_subsidy,
2357: hoi.org_information16 refunds
2358: from hr_organization_units hou
2359: ,hr_organization_information hoi
2360: where hoi.org_information_context='IE_EHECS'
2361: and hoi.organization_id=c_org_id
2362: and hoi.organization_id=hou.organization_id
2363: and hou.business_group_id= c_bg_id