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

Line 253: l_business_id hr_organization_information.org_information1%TYPE ;

249: l_test_submission varchar2(1);
250: -- l_company_terminating varchar2(1); bug 10367494
251: l_emp_id hr_organization_units.organization_id%TYPE ;
252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
256: l_org_type hr_organization_information.org_information1%TYPE ;
257: l_date VARCHAR2(100);

Line 254: l_cvr_number hr_organization_information.org_information1%TYPE ;

250: -- l_company_terminating varchar2(1); bug 10367494
251: l_emp_id hr_organization_units.organization_id%TYPE ;
252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
256: l_org_type hr_organization_information.org_information1%TYPE ;
257: l_date VARCHAR2(100);
258: l_time VARCHAR2(10);

Line 255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

251: l_emp_id hr_organization_units.organization_id%TYPE ;
252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
256: l_org_type hr_organization_information.org_information1%TYPE ;
257: l_date VARCHAR2(100);
258: l_time VARCHAR2(10);
259:

Line 256: l_org_type hr_organization_information.org_information1%TYPE ;

252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
256: l_org_type hr_organization_information.org_information1%TYPE ;
257: l_date VARCHAR2(100);
258: l_time VARCHAR2(10);
259:
260: l_date_id VARCHAR2(20);

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

269:
270: /*Cursors */
271:
272: /*Legal Employer Information*/
273: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
274: IS
275: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
276: FROM hr_organization_units o1
277: , hr_organization_information hoi1

Line 277: , hr_organization_information hoi1

273: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
274: IS
275: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
276: FROM hr_organization_units o1
277: , hr_organization_information hoi1
278: , hr_organization_information hoi2
279: WHERE o1.business_group_id =l_business_group_id
280: AND hoi1.organization_id = o1.organization_id
281: AND hoi1.organization_id = csr_v_legal_emp_id

Line 278: , hr_organization_information hoi2

274: IS
275: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
276: FROM hr_organization_units o1
277: , hr_organization_information hoi1
278: , hr_organization_information hoi2
279: WHERE o1.business_group_id =l_business_group_id
280: AND hoi1.organization_id = o1.organization_id
281: AND hoi1.organization_id = csr_v_legal_emp_id
282: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 290: Cursor csr_Legal_Emp_MO_FO_FH ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)

286:
287: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
288:
289: /*Legal Employer MO, FO, EH Codes */
290: Cursor csr_Legal_Emp_MO_FO_FH ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
291: IS
292: SELECT
293: hoi2.ORG_INFORMATION2,
294: hoi2.ORG_INFORMATION3,

Line 299: , hr_organization_information hoi1

295: hoi2.ORG_INFORMATION4,
296: hoi2.ORG_INFORMATION5,
297: hoi2.ORG_INFORMATION6
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id =l_business_group_id
302: AND hoi1.organization_id = o1.organization_id
303: AND hoi1.organization_id = csr_v_legal_emp_id

Line 300: , hr_organization_information hoi2

296: hoi2.ORG_INFORMATION5,
297: hoi2.ORG_INFORMATION6
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id =l_business_group_id
302: AND hoi1.organization_id = o1.organization_id
303: AND hoi1.organization_id = csr_v_legal_emp_id
304: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 315: select * from hr_organization_information

311:
312: -- Service Provider information.
313: cursor service_provider_details
314: is
315: select * from hr_organization_information
316: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
317: and organization_id in (
318: select organization_id from hr_organization_units
319: where business_group_id= l_business_group_id);

Line 366: hr_organization_information hoi,

362: FROM
363: pay_payrolls_f ppf,
364: per_assignments_f paf,
365: hr_organization_units hou,
366: hr_organization_information hoi,
367: hr_soft_coding_keyflex scl,
368: per_time_periods ptp
369: WHERE hou.business_group_id = l_business_group_id
370: AND hou.organization_id = g_legal_employer_id

Line 397: FROM hr_organization_information

393: l_report_type VARCHAR2(100);
394:
395: CURSOR csr_use_hol_card(p_org_id NUMBER) is
396: SELECT NVL(org_information5,'N')
397: FROM hr_organization_information
398: WHERE organization_id = p_org_id
399: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
400:
401: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS

Line 1057: , HR_ORGANIZATION_INFORMATION hoi1

1053: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE
1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE
1056: FROM HR_ORGANIZATION_UNITS hou
1057: , HR_ORGANIZATION_INFORMATION hoi1
1058: , HR_ORGANIZATION_INFORMATION hoi2
1059: WHERE hou.business_group_id = p_business_group_id
1060: and hoi1.organization_id = hou.organization_id
1061: and hoi1.organization_id = p_le_id

Line 1058: , HR_ORGANIZATION_INFORMATION hoi2

1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE
1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE
1056: FROM HR_ORGANIZATION_UNITS hou
1057: , HR_ORGANIZATION_INFORMATION hoi1
1058: , HR_ORGANIZATION_INFORMATION hoi2
1059: WHERE hou.business_group_id = p_business_group_id
1060: and hoi1.organization_id = hou.organization_id
1061: and hoi1.organization_id = p_le_id
1062: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 1089: , HR_ORGANIZATION_INFORMATION hoi1

1085: ,loc.REGION_2
1086: ,loc.REGION_3
1087: ,loc.style
1088: FROM HR_ORGANIZATION_UNITS hou
1089: , HR_ORGANIZATION_INFORMATION hoi1
1090: , HR_ORGANIZATION_INFORMATION hoi2
1091: , HR_LOCATIONS loc
1092: WHERE hou.business_group_id = p_business_group_id
1093: and hou.organization_id = p_le_id

Line 1090: , HR_ORGANIZATION_INFORMATION hoi2

1086: ,loc.REGION_3
1087: ,loc.style
1088: FROM HR_ORGANIZATION_UNITS hou
1089: , HR_ORGANIZATION_INFORMATION hoi1
1090: , HR_ORGANIZATION_INFORMATION hoi2
1091: , HR_LOCATIONS loc
1092: WHERE hou.business_group_id = p_business_group_id
1093: and hou.organization_id = p_le_id
1094: and hoi1.organization_id = hou.organization_id

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

1180: /* Cursor to get SE Number, PUCODE at HR Org level */
1181:
1182: CURSOR csr_get_hr_org_info(
1183: bg_id hr_organization_units.business_group_id%type
1184: ,hr_org_id hr_organization_information.organization_id%type) IS
1185: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
1186: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1187: FROM hr_organization_units o1
1188: , hr_organization_information hoi1

Line 1188: , hr_organization_information hoi1

1184: ,hr_org_id hr_organization_information.organization_id%type) IS
1185: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
1186: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1187: FROM hr_organization_units o1
1188: , hr_organization_information hoi1
1189: , hr_organization_information hoi2
1190: WHERE o1.business_group_id =bg_id
1191: AND hoi1.organization_id = o1.organization_id
1192: AND hoi1.organization_id = hr_org_id

Line 1189: , hr_organization_information hoi2

1185: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
1186: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1187: FROM hr_organization_units o1
1188: , hr_organization_information hoi1
1189: , hr_organization_information hoi2
1190: WHERE o1.business_group_id =bg_id
1191: AND hoi1.organization_id = o1.organization_id
1192: AND hoi1.organization_id = hr_org_id
1193: AND hoi1.org_information1 = 'HR_ORG'

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

1214:
1215: rg_csr_pay_periods csr_pay_periods%rowtype;
1216:
1217: /* Cursor to get the details of the legal employer */
1218: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
1219: IS
1220: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1221: FROM hr_organization_units o1
1222: , hr_organization_information hoi1

Line 1222: , hr_organization_information hoi1

1218: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
1219: IS
1220: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1221: FROM hr_organization_units o1
1222: , hr_organization_information hoi1
1223: , hr_organization_information hoi2
1224: WHERE o1.business_group_id =g_business_group_id
1225: AND hoi1.organization_id = o1.organization_id
1226: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1223: , hr_organization_information hoi2

1219: IS
1220: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1221: FROM hr_organization_units o1
1222: , hr_organization_information hoi1
1223: , hr_organization_information hoi2
1224: WHERE o1.business_group_id =g_business_group_id
1225: AND hoi1.organization_id = o1.organization_id
1226: AND hoi1.organization_id = csr_v_legal_emp_id
1227: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1455: FROM hr_organization_information

1451:
1452: --13463885
1453: CURSOR csr_use_hol_card(p_org_id NUMBER) is
1454: SELECT NVL(org_information5,'N')
1455: FROM hr_organization_information
1456: WHERE organization_id = p_org_id
1457: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
1458:
1459: CURSOR get_value_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS

Line 1507: Cursor csr_Legal_Emp_DA_Codes ( p_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE

1503:
1504: l_usr_tbl_exist_400 VARCHAR2(1) := 'N';
1505:
1506: /*Legal Employer DA Office Codes */
1507: Cursor csr_Legal_Emp_DA_Codes ( p_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
1508: ,p_business_group_id NUMBER)
1509: IS
1510: SELECT
1511: hoi2.ORG_INFORMATION2,

Line 1517: , hr_organization_information hoi1

1513: hoi2.ORG_INFORMATION4,
1514: hoi2.ORG_INFORMATION5,
1515: hoi2.ORG_INFORMATION6
1516: FROM hr_organization_units o1
1517: , hr_organization_information hoi1
1518: , hr_organization_information hoi2
1519: WHERE o1.business_group_id = p_business_group_id
1520: AND hoi1.organization_id = o1.organization_id
1521: AND hoi1.organization_id = p_legal_emp_id

Line 1518: , hr_organization_information hoi2

1514: hoi2.ORG_INFORMATION5,
1515: hoi2.ORG_INFORMATION6
1516: FROM hr_organization_units o1
1517: , hr_organization_information hoi1
1518: , hr_organization_information hoi2
1519: WHERE o1.business_group_id = p_business_group_id
1520: AND hoi1.organization_id = o1.organization_id
1521: AND hoi1.organization_id = p_legal_emp_id
1522: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1634: l_cvr_number hr_organization_information.org_information1%TYPE ;

1630: l_gross_income NUMBER(12,2);
1631: l_emp_atp NUMBER(12,2);
1632: l_amb_pay NUMBER(12,2);
1633: l_amb NUMBER(12,2);
1634: l_cvr_number hr_organization_information.org_information1%TYPE ;
1635: l_cpr_number VARCHAR2(15);
1636: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1637: l_total_atp_hours NUMBER;
1638: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494

Line 1636: l_pu_code hr_organization_information.ORG_INFORMATION6%type;

1632: l_amb_pay NUMBER(12,2);
1633: l_amb NUMBER(12,2);
1634: l_cvr_number hr_organization_information.org_information1%TYPE ;
1635: l_cpr_number VARCHAR2(15);
1636: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1637: l_total_atp_hours NUMBER;
1638: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494
1639: l_company_terminating varchar2(1); -- bug 10367494
1640: l_flag1 NUMBER :=0 ;

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

1634: l_cvr_number hr_organization_information.org_information1%TYPE ;
1635: l_cpr_number VARCHAR2(15);
1636: l_pu_code hr_organization_information.ORG_INFORMATION6%type;
1637: l_total_atp_hours NUMBER;
1638: l_se_no hr_organization_information.ORG_INFORMATION5%type; -- bug 10367494
1639: l_company_terminating varchar2(1); -- bug 10367494
1640: l_flag1 NUMBER :=0 ;
1641: l_atp NUMBER;
1642: L_6005_SIGN VARCHAR2(1);