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

Line 159: l_business_id hr_organization_information.org_information1%TYPE ;

155: l_test_submission varchar2(1);
156: l_company_terminating varchar2(1);
157: l_emp_id hr_organization_units.organization_id%TYPE ;
158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
162: l_org_type hr_organization_information.org_information1%TYPE ;
163: l_date VARCHAR2(100);

Line 160: l_cvr_number hr_organization_information.org_information1%TYPE ;

156: l_company_terminating varchar2(1);
157: l_emp_id hr_organization_units.organization_id%TYPE ;
158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
162: l_org_type hr_organization_information.org_information1%TYPE ;
163: l_date VARCHAR2(100);
164: l_time VARCHAR2(10);

Line 161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

157: l_emp_id hr_organization_units.organization_id%TYPE ;
158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
162: l_org_type hr_organization_information.org_information1%TYPE ;
163: l_date VARCHAR2(100);
164: l_time VARCHAR2(10);
165: l_lb_num VARCHAR2(10);

Line 162: l_org_type hr_organization_information.org_information1%TYPE ;

158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
162: l_org_type hr_organization_information.org_information1%TYPE ;
163: l_date VARCHAR2(100);
164: l_time VARCHAR2(10);
165: l_lb_num VARCHAR2(10);
166:

Line 170: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

166:
167: /*Cursors */
168:
169: /*Legal Employer Information*/
170: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
171: IS
172: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
173: FROM hr_organization_units o1
174: , hr_organization_information hoi1

Line 174: , hr_organization_information hoi1

170: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
171: IS
172: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
173: FROM hr_organization_units o1
174: , hr_organization_information hoi1
175: , hr_organization_information hoi2
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id
178: AND hoi1.organization_id = csr_v_legal_emp_id

Line 175: , hr_organization_information hoi2

171: IS
172: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
173: FROM hr_organization_units o1
174: , hr_organization_information hoi1
175: , hr_organization_information hoi2
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id
178: AND hoi1.organization_id = csr_v_legal_emp_id
179: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 189: select * from hr_organization_information

185:
186: -- Service Provider information.
187: cursor service_provider_details
188: is
189: select * from hr_organization_information
190: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
191: and organization_id in (
192: select organization_id from hr_organization_units
193: where business_group_id= l_business_group_id);

Line 769: ,hr_org_id hr_organization_information.organization_id%type) IS

765: /* Cursor to get SE Number, PUCODE at HR Org level */
766:
767: CURSOR csr_get_hr_org_info(
768: bg_id hr_organization_units.business_group_id%type
769: ,hr_org_id hr_organization_information.organization_id%type) IS
770: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
771: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
772: FROM hr_organization_units o1
773: , hr_organization_information hoi1

Line 773: , hr_organization_information hoi1

769: ,hr_org_id hr_organization_information.organization_id%type) IS
770: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
771: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
772: FROM hr_organization_units o1
773: , hr_organization_information hoi1
774: , hr_organization_information hoi2
775: WHERE o1.business_group_id =bg_id
776: AND hoi1.organization_id = o1.organization_id
777: AND hoi1.organization_id = hr_org_id

Line 774: , hr_organization_information hoi2

770: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
771: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
772: FROM hr_organization_units o1
773: , hr_organization_information hoi1
774: , hr_organization_information hoi2
775: WHERE o1.business_group_id =bg_id
776: AND hoi1.organization_id = o1.organization_id
777: AND hoi1.organization_id = hr_org_id
778: AND hoi1.org_information1 = 'HR_ORG'

Line 802: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

798:
799: rg_csr_pay_periods csr_pay_periods%rowtype;
800:
801: /* Cursor to get the details of the legal employer */
802: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
803: IS
804: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
805: FROM hr_organization_units o1
806: , hr_organization_information hoi1

Line 806: , hr_organization_information hoi1

802: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
803: IS
804: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
805: FROM hr_organization_units o1
806: , hr_organization_information hoi1
807: , hr_organization_information hoi2
808: WHERE o1.business_group_id =g_business_group_id
809: AND hoi1.organization_id = o1.organization_id
810: AND hoi1.organization_id = csr_v_legal_emp_id

Line 807: , hr_organization_information hoi2

803: IS
804: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
805: FROM hr_organization_units o1
806: , hr_organization_information hoi1
807: , hr_organization_information hoi2
808: WHERE o1.business_group_id =g_business_group_id
809: AND hoi1.organization_id = o1.organization_id
810: AND hoi1.organization_id = csr_v_legal_emp_id
811: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 977: l_cvr_number hr_organization_information.org_information1%TYPE ;

973: l_gross_income NUMBER(12,2);
974: l_emp_atp NUMBER(12,2);
975: l_amb_pay NUMBER(12,2);
976: l_amb NUMBER(12,2);
977: l_cvr_number hr_organization_information.org_information1%TYPE ;
978: l_cpr_number VARCHAR(15);
979: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
980: l_total_atp_hours NUMBER;
981: l_atp NUMBER;

Line 979: l_pu_code hr_organization_information.ORG_INFORMATION6%type;

975: l_amb_pay NUMBER(12,2);
976: l_amb NUMBER(12,2);
977: l_cvr_number hr_organization_information.org_information1%TYPE ;
978: l_cpr_number VARCHAR(15);
979: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
980: l_total_atp_hours NUMBER;
981: l_atp NUMBER;
982: L_6005_SIGN VARCHAR2(1);
983: l_bg_id NUMBER;