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 212: l_business_id hr_organization_information.org_information1%TYPE ;

208: l_test_submission varchar2(1);
209: -- l_company_terminating varchar2(1); bug 10367494
210: l_emp_id hr_organization_units.organization_id%TYPE ;
211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
215: l_org_type hr_organization_information.org_information1%TYPE ;
216: l_date VARCHAR2(100);

Line 213: l_cvr_number hr_organization_information.org_information1%TYPE ;

209: -- l_company_terminating varchar2(1); bug 10367494
210: l_emp_id hr_organization_units.organization_id%TYPE ;
211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
215: l_org_type hr_organization_information.org_information1%TYPE ;
216: l_date VARCHAR2(100);
217: l_time VARCHAR2(10);

Line 214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

210: l_emp_id hr_organization_units.organization_id%TYPE ;
211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
215: l_org_type hr_organization_information.org_information1%TYPE ;
216: l_date VARCHAR2(100);
217: l_time VARCHAR2(10);
218: l_lb_num VARCHAR2(10);

Line 215: l_org_type hr_organization_information.org_information1%TYPE ;

211: l_le_name hr_organization_units.name%TYPE ;
212: l_business_id hr_organization_information.org_information1%TYPE ;
213: l_cvr_number hr_organization_information.org_information1%TYPE ;
214: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
215: l_org_type hr_organization_information.org_information1%TYPE ;
216: l_date VARCHAR2(100);
217: l_time VARCHAR2(10);
218: l_lb_num VARCHAR2(10);
219: l_unique_id VARCHAR2(16);

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

224:
225: /*Cursors */
226:
227: /*Legal Employer Information*/
228: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
229: IS
230: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
231: FROM hr_organization_units o1
232: , hr_organization_information hoi1

Line 232: , hr_organization_information hoi1

228: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
229: IS
230: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
231: FROM hr_organization_units o1
232: , hr_organization_information hoi1
233: , hr_organization_information hoi2
234: WHERE o1.business_group_id =l_business_group_id
235: AND hoi1.organization_id = o1.organization_id
236: AND hoi1.organization_id = csr_v_legal_emp_id

Line 233: , hr_organization_information hoi2

229: IS
230: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
231: FROM hr_organization_units o1
232: , hr_organization_information hoi1
233: , hr_organization_information hoi2
234: WHERE o1.business_group_id =l_business_group_id
235: AND hoi1.organization_id = o1.organization_id
236: AND hoi1.organization_id = csr_v_legal_emp_id
237: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 247: select * from hr_organization_information

243:
244: -- Service Provider information.
245: cursor service_provider_details
246: is
247: select * from hr_organization_information
248: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
249: and organization_id in (
250: select organization_id from hr_organization_units
251: where business_group_id= l_business_group_id);

Line 298: hr_organization_information hoi,

294: FROM
295: pay_payrolls_f ppf,
296: per_assignments_f paf,
297: hr_organization_units hou,
298: hr_organization_information hoi,
299: hr_soft_coding_keyflex scl,
300: per_time_periods ptp
301: WHERE hou.business_group_id = l_business_group_id
302: AND hou.organization_id = g_legal_employer_id

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

913: /* Cursor to get SE Number, PUCODE at HR Org level */
914:
915: CURSOR csr_get_hr_org_info(
916: bg_id hr_organization_units.business_group_id%type
917: ,hr_org_id hr_organization_information.organization_id%type) IS
918: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
919: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
920: FROM hr_organization_units o1
921: , hr_organization_information hoi1

Line 921: , hr_organization_information hoi1

917: ,hr_org_id hr_organization_information.organization_id%type) IS
918: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
919: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
920: FROM hr_organization_units o1
921: , hr_organization_information hoi1
922: , hr_organization_information hoi2
923: WHERE o1.business_group_id =bg_id
924: AND hoi1.organization_id = o1.organization_id
925: AND hoi1.organization_id = hr_org_id

Line 922: , hr_organization_information hoi2

918: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
919: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
920: FROM hr_organization_units o1
921: , hr_organization_information hoi1
922: , hr_organization_information hoi2
923: WHERE o1.business_group_id =bg_id
924: AND hoi1.organization_id = o1.organization_id
925: AND hoi1.organization_id = hr_org_id
926: AND hoi1.org_information1 = 'HR_ORG'

Line 934: CURSOR csr_chk_2001 (p_se_no hr_organization_information.ORG_INFORMATION5%type) IS

930:
931: rg_csr_get_hr_org_info csr_get_hr_org_info%rowtype;
932:
933: --bug 10367494
934: CURSOR csr_chk_2001 (p_se_no hr_organization_information.ORG_INFORMATION5%type) IS
935:
936: SELECT 1
937: FROM pay_action_information pai
938: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'

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

957:
958: rg_csr_pay_periods csr_pay_periods%rowtype;
959:
960: /* Cursor to get the details of the legal employer */
961: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
962: IS
963: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
964: FROM hr_organization_units o1
965: , hr_organization_information hoi1

Line 965: , hr_organization_information hoi1

961: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
962: IS
963: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
964: FROM hr_organization_units o1
965: , hr_organization_information hoi1
966: , hr_organization_information hoi2
967: WHERE o1.business_group_id =g_business_group_id
968: AND hoi1.organization_id = o1.organization_id
969: AND hoi1.organization_id = csr_v_legal_emp_id

Line 966: , hr_organization_information hoi2

962: IS
963: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
964: FROM hr_organization_units o1
965: , hr_organization_information hoi1
966: , hr_organization_information hoi2
967: WHERE o1.business_group_id =g_business_group_id
968: AND hoi1.organization_id = o1.organization_id
969: AND hoi1.organization_id = csr_v_legal_emp_id
970: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1176: FROM hr_organization_information

1172:
1173: --13463885
1174: CURSOR csr_use_hol_card(p_org_id NUMBER) is
1175: SELECT NVL(org_information5,'N')
1176: FROM hr_organization_information
1177: WHERE organization_id = p_org_id
1178: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1179:
1180: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS

Line 1332: l_cvr_number hr_organization_information.org_information1%TYPE ;

1328: l_gross_income NUMBER(12,2);
1329: l_emp_atp NUMBER(12,2);
1330: l_amb_pay NUMBER(12,2);
1331: l_amb NUMBER(12,2);
1332: l_cvr_number hr_organization_information.org_information1%TYPE ;
1333: l_cpr_number VARCHAR2(15);
1334: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1335: l_total_atp_hours NUMBER;
1336: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494

Line 1334: l_pu_code hr_organization_information.ORG_INFORMATION6%type;

1330: l_amb_pay NUMBER(12,2);
1331: l_amb NUMBER(12,2);
1332: l_cvr_number hr_organization_information.org_information1%TYPE ;
1333: l_cpr_number VARCHAR2(15);
1334: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1335: l_total_atp_hours NUMBER;
1336: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494
1337: l_company_terminating varchar2(1); -- bug 10367494
1338: l_flag1 NUMBER :=0 ;

Line 1336: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494

1332: l_cvr_number hr_organization_information.org_information1%TYPE ;
1333: l_cpr_number VARCHAR2(15);
1334: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1335: l_total_atp_hours NUMBER;
1336: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494
1337: l_company_terminating varchar2(1); -- bug 10367494
1338: l_flag1 NUMBER :=0 ;
1339: l_atp NUMBER;
1340: L_6005_SIGN VARCHAR2(1);