APPS.PAY_IE_NES_REPORT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 579: ,c_bg_id hr_organization_units.business_group_id%type) IS

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
583: ,hla.address_line_2 addr2

Line 591: from hr_organization_units hou

587: ,hla.TOWN_OR_CITY City
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'

Line 606: ,c_bg_id hr_organization_units.business_group_id%type

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
610: ,hoi.org_information13 person_id

Line 614: from hr_organization_units hou

610: ,hoi.org_information13 person_id
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

Line 634: l_org_id hr_organization_units.organization_id%type;

630: l_declarant csr_declarant%rowtype;
631: l_declarant_details csr_declarant_details%rowtype;
632: l_action_info_id NUMBER;
633: l_ovn NUMBER;
634: l_org_id hr_organization_units.organization_id%type;
635: l_employer_name hr_organization_units.name%type;
636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;

Line 635: l_employer_name hr_organization_units.name%type;

631: l_declarant_details csr_declarant_details%rowtype;
632: l_action_info_id NUMBER;
633: l_ovn NUMBER;
634: l_org_id hr_organization_units.organization_id%type;
635: l_employer_name hr_organization_units.name%type;
636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;

Line 1247: ,c_bg_id hr_organization_units.business_group_id%type

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

Line 1250: from hr_organization_units hou

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
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

Line 1440: l_org_id hr_organization_units.organization_id%type;

1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;
1437:
1438: l_valid_asg_rec cur_valid_asg%ROWTYPE;
1439: l_hours_per_day varchar2(10);
1440: l_org_id hr_organization_units.organization_id%type;
1441: l_normal_hours per_all_assignments_f.normal_hours%type;
1442: l_frequency per_all_assignments_f.frequency%type;
1443:
1444: Type tab_address is table of per_addresses.ADDRESS_LINE1%type index by binary_integer;