APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on HR_ORGANIZATION_INFORMATION

Line 21: g_se_no hr_organization_information.org_information5%TYPE ;

17: g_time_created varchar2(10);
18: g_run_id varchar2(50);
19: g_payroll_name VARCHAR2(52);
20: g_version varchar2(20);
21: g_se_no hr_organization_information.org_information5%TYPE ;
22: g_cvr_no hr_organization_information.org_information1%TYPE ;
23: g_date_last_changed varchar2(10);
24: g_company_name varchar2(255);
25: g_count_employee number;

Line 22: g_cvr_no hr_organization_information.org_information1%TYPE ;

18: g_run_id varchar2(50);
19: g_payroll_name VARCHAR2(52);
20: g_version varchar2(20);
21: g_se_no hr_organization_information.org_information5%TYPE ;
22: g_cvr_no hr_organization_information.org_information1%TYPE ;
23: g_date_last_changed varchar2(10);
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;

Line 29: g_legal_employer_id hr_organization_information.organization_id%type;

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:
33: TYPE error_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,

Line 633: CURSOR csr_Legal_Emp_Details ( p_se_no hr_organization_information.ORG_INFORMATION5%TYPE

629: , p_effective_date date
630: , retcode OUT NOCOPY varchar2)
631: IS
632:
633: CURSOR csr_Legal_Emp_Details ( p_se_no hr_organization_information.ORG_INFORMATION5%TYPE
634: ,p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)
635: IS
636: SELECT o1.name le_name ,
637: hoi2.organization_id org_id,

Line 634: ,p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)

630: , retcode OUT NOCOPY varchar2)
631: IS
632:
633: CURSOR csr_Legal_Emp_Details ( p_se_no hr_organization_information.ORG_INFORMATION5%TYPE
634: ,p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)
635: IS
636: SELECT o1.name le_name ,
637: hoi2.organization_id org_id,
638: hoi2.ORG_INFORMATION1 cvr_no,

Line 644: , hr_organization_information hoi1

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
648: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 645: , hr_organization_information hoi2

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
648: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
649: AND hoi1.org_information_context = 'CLASS'

Line 660: CURSOR service_provider_details(p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)

656: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
657:
658:
659: -- Service Provider information.
660: CURSOR service_provider_details(p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)
661: IS
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'

Line 663: FROM hr_organization_information

659: -- Service Provider information.
660: CURSOR service_provider_details(p_cvr_no hr_organization_information.ORG_INFORMATION1%TYPE)
661: IS
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)

Line 683: hr_organization_information hoi,

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
687: AND hou.organization_id = g_legal_employer_id

Line 710: , HR_ORGANIZATION_INFORMATION hoi1

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
714: AND hoi1.organization_id = p_le_id

Line 711: , HR_ORGANIZATION_INFORMATION hoi2

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
714: AND hoi1.organization_id = p_le_id
715: AND hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 723: l_work_pattern HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%type;

719: AND hoi2.organization_id = hoi1.organization_id
720: AND p_effective_date BETWEEN hou.DATE_FROM AND nvl(hou.DATE_TO, p_effective_date);
721:
722: l_5d_6d hr_soft_coding_keyflex.SEGMENT10%type;
723: l_work_pattern HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%type;
724: l_ass_no per_assignments_f.ASSIGNMENT_NUMBER%TYPE;
725: l_cvr_no per_people_f.NATIONAL_IDENTIFIER%TYPE;
726: l_flag number;
727: l_start_date date;