APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on HR_ORGANIZATION_UNITS

Line 28: g_business_group_id hr_organization_units.business_group_id%type;

24: g_company_name varchar2(255);
25: g_count_employee number;
26: g_absence_attendance_type_id per_absence_attendance_types.absence_attendance_type_id%type;
27: g_test_submission varchar2(1) ;
28: g_business_group_id hr_organization_units.business_group_id%type;
29: g_legal_employer_id hr_organization_information.organization_id%type;
30: g_effective_date date;
31: g_vendor_id varchar2(25);
32:

Line 579: l_business_group_id hr_organization_units.business_group_id%type;

575: l_start_date date;
576: l_end_date date;
577: l_effective_date DATE;
578: l_person_id per_all_people_f.person_id%type;
579: l_business_group_id hr_organization_units.business_group_id%type;
580: l_abs_attendance_id per_absence_attendance_types.absence_attendance_type_id%type;
581: --l_assignment_id number;
582:
583: BEGIN

Line 643: FROM hr_organization_units o1

639: hoi2.ORG_INFORMATION2,
640: hoi2.ORG_INFORMATION3,
641: hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5 se_no,
642: hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
643: FROM hr_organization_units o1
644: , hr_organization_information hoi1
645: , hr_organization_information hoi2
646: WHERE o1.business_group_id = p_business_group_id
647: AND hoi1.organization_id = o1.organization_id

Line 666: select organization_id from hr_organization_units

662: SELECT ORGANIZATION_ID org_id,ORG_INFORMATION1 cvr_no,ORG_INFORMATION3
663: FROM hr_organization_information
664: WHERE org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
665: AND organization_id in (
666: select organization_id from hr_organization_units
667: where business_group_id= p_business_group_id)
668: AND org_information1 = p_cvr_no ;
669:
670: sp service_provider_details%rowtype;

Line 682: hr_organization_units hou,

678: ppf.payroll_id payroll_id ,
679: ppf.PRL_INFORMATION1 holiday_card
680: FROM pay_payrolls_f ppf,
681: per_assignments_f paf,
682: hr_organization_units hou,
683: hr_organization_information hoi,
684: hr_soft_coding_keyflex scl ,
685: per_people_f papf
686: WHERE hou.business_group_id = p_business_group_id

Line 709: FROM HR_ORGANIZATION_UNITS hou

705: /* Cursor to fetch the Legal Employer level Holiday Entitlement */
706: CURSOR csr_get_hol_entity(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
707: SELECT hoi2.ORG_INFORMATION1 def_wrk_patt,
708: NVL(hoi2.org_information5,'N') holiday_card
709: FROM HR_ORGANIZATION_UNITS hou
710: , HR_ORGANIZATION_INFORMATION hoi1
711: , HR_ORGANIZATION_INFORMATION hoi2
712: WHERE hou.business_group_id = p_business_group_id
713: AND hoi1.organization_id = hou.organization_id