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_NL_REM_REPORT dependencies on FND_DATE

Line 1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from

1065: To get Labour Handicap Discount
1066: ***********************************************************/
1067: CURSOR cur_get_lhd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1068: SELECT paei.aei_information3 lhd_type
1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from
1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei
1072: WHERE paei.aei_information_category = 'NL_LHI'
1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date

Line 1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to

1066: ***********************************************************/
1067: CURSOR cur_get_lhd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1068: SELECT paei.aei_information3 lhd_type
1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from
1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei
1072: WHERE paei.aei_information_category = 'NL_LHI'
1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date
1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date

Line 1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date

1069: ,fnd_date.canonical_to_date (paei.aei_information1) date_from
1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei
1072: WHERE paei.aei_information_category = 'NL_LHI'
1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date
1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1075: AND paei.assignment_id = c_assignment_id
1076: AND paei.aei_information3 IN ('1','2','3','4')
1077: ORDER BY fnd_date.canonical_to_date (paei.aei_information1);

Line 1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date

1070: ,fnd_date.canonical_to_date (paei.aei_information2) date_to
1071: FROM per_assignment_extra_info paei
1072: WHERE paei.aei_information_category = 'NL_LHI'
1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date
1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1075: AND paei.assignment_id = c_assignment_id
1076: AND paei.aei_information3 IN ('1','2','3','4')
1077: ORDER BY fnd_date.canonical_to_date (paei.aei_information1);
1078: --=============================================================================

Line 1077: ORDER BY fnd_date.canonical_to_date (paei.aei_information1);

1073: AND fnd_date.canonical_to_date (aei_information1) < l_reporting_date
1074: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1075: AND paei.assignment_id = c_assignment_id
1076: AND paei.aei_information3 IN ('1','2','3','4')
1077: ORDER BY fnd_date.canonical_to_date (paei.aei_information1);
1078: --=============================================================================
1079: /***********************************************************
1080: To get Temporary Tax Discount
1081: ***********************************************************/

Line 1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from

1080: To get Temporary Tax Discount
1081: ***********************************************************/
1082: CURSOR cur_get_ttd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1083: SELECT paei.aei_information3 ttd_type
1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from
1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei
1087: WHERE paei.aei_information_category = 'NL_TTD'
1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date

Line 1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to

1081: ***********************************************************/
1082: CURSOR cur_get_ttd_details(c_assignment_id per_all_assignments_f.assignment_id%TYPE) IS
1083: SELECT paei.aei_information3 ttd_type
1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from
1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei
1087: WHERE paei.aei_information_category = 'NL_TTD'
1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date
1089: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date

Line 1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date

1084: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information1) date_from
1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei
1087: WHERE paei.aei_information_category = 'NL_TTD'
1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date
1089: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1090: AND paei.assignment_id = c_assignment_id
1091: AND paei.aei_information3 = '2'
1092: ORDER BY paei.aei_information1;

Line 1089: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date

1085: ,FND_DATE.CANONICAL_TO_DATE(paei.aei_information2) date_to
1086: FROM per_assignment_extra_info paei
1087: WHERE paei.aei_information_category = 'NL_TTD'
1088: AND FND_DATE.CANONICAL_TO_DATE(aei_information1) < l_reporting_date
1089: AND NVL(fnd_date.canonical_to_date (aei_information2),hr_general.end_of_time) > l_reporting_start_date
1090: AND paei.assignment_id = c_assignment_id
1091: AND paei.aei_information3 = '2'
1092: ORDER BY paei.aei_information1;
1093: --=============================================================================

Line 1233: l_reporting_date := fnd_date.canonical_to_date(p_end_of_year);

1229: CLOSE cur_get_bg_name;
1230:
1231: /*Set Reporting Dates based on pay period */
1232: IF (p_pay_period) IS NULL THEN
1233: l_reporting_date := fnd_date.canonical_to_date(p_end_of_year);
1234: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1235: ELSE
1236: l_reporting_date := LAST_DAY(fnd_date.canonical_to_date(p_pay_period));
1237: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_pay_period),'MM');

Line 1234: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');

1230:
1231: /*Set Reporting Dates based on pay period */
1232: IF (p_pay_period) IS NULL THEN
1233: l_reporting_date := fnd_date.canonical_to_date(p_end_of_year);
1234: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1235: ELSE
1236: l_reporting_date := LAST_DAY(fnd_date.canonical_to_date(p_pay_period));
1237: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_pay_period),'MM');
1238: END IF;

Line 1236: l_reporting_date := LAST_DAY(fnd_date.canonical_to_date(p_pay_period));

1232: IF (p_pay_period) IS NULL THEN
1233: l_reporting_date := fnd_date.canonical_to_date(p_end_of_year);
1234: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1235: ELSE
1236: l_reporting_date := LAST_DAY(fnd_date.canonical_to_date(p_pay_period));
1237: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_pay_period),'MM');
1238: END IF;
1239:
1240: /*Fecth Org Struct Version ID */

Line 1237: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_pay_period),'MM');

1233: l_reporting_date := fnd_date.canonical_to_date(p_end_of_year);
1234: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1235: ELSE
1236: l_reporting_date := LAST_DAY(fnd_date.canonical_to_date(p_pay_period));
1237: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_pay_period),'MM');
1238: END IF;
1239:
1240: /*Fecth Org Struct Version ID */
1241: OPEN get_org_struct_version_id(p_org_struct_id);

Line 1253: Tag('EFFECTIVE_DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_effective_date)));

1249: Tag('DUTCH_REM','_START_');
1250:
1251: /*Display Parameters */
1252: Tag('BG_NAME',l_bg_name);
1253: Tag('EFFECTIVE_DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_effective_date)));
1254: Tag('P_PAYROLL_PERIOD',p_pay_period);
1255: Tag('P_YEAR',to_char(fnd_date.canonical_to_date(p_end_of_year),'YYYY'));
1256: Tag('P_ORG_STRUCT_NAME',p_org_struct_name);
1257: Tag('P_TOP_ORG_NAME',p_top_org_name);

Line 1255: Tag('P_YEAR',to_char(fnd_date.canonical_to_date(p_end_of_year),'YYYY'));

1251: /*Display Parameters */
1252: Tag('BG_NAME',l_bg_name);
1253: Tag('EFFECTIVE_DATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_effective_date)));
1254: Tag('P_PAYROLL_PERIOD',p_pay_period);
1255: Tag('P_YEAR',to_char(fnd_date.canonical_to_date(p_end_of_year),'YYYY'));
1256: Tag('P_ORG_STRUCT_NAME',p_org_struct_name);
1257: Tag('P_TOP_ORG_NAME',p_top_org_name);
1258: Tag('P_SUB_EMP',get_lookup_value('HR_NL_YES_NO',p_sub_emp,userenv('lang')));
1259: Tag('P_EMPLOYEE_NAME',p_employee_name);

Line 1375: fnd_date.date_to_chardate(l_temp_date_to+1));

1371: IF l_temp_date_to<> hr_general.end_of_time AND l_temp_date_to IS NOT NULL AND l_wage_table_status <> 'N' THEN
1372: Tag('WAGE_TABLE','_START_');
1373: Tag('WAGE_TAX_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1374: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1375: fnd_date.date_to_chardate(l_temp_date_to+1));
1376: Tag('WAGE_TABLE','_END_');
1377: l_wage_table_status := 'N';
1378: END IF;
1379: IF l_emp_count1=0 THEN

Line 1391: fnd_date.date_to_chardate(l_temp_date_to+1));

1387: IF l_temp_date_to+1'N' THEN
1388: Tag('WAGE_TABLE','_START_');
1389: Tag('WAGE_TAX_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1390: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1391: fnd_date.date_to_chardate(l_temp_date_to+1));
1392: Tag('WAGE_TABLE','_END_');
1393: l_wage_table_status := 'N';
1394: l_emp_count1 := l_emp_count1+1;
1395: END IF;

Line 1402: fnd_date.date_to_chardate(r_wage_table_det.effectivefrom));

1398: l_temp_date_to := NVL(r_wage_table_det.effectiveto,hr_general.end_of_time);
1399: Tag('WAGE_TABLE','_START_');
1400: Tag('WAGE_TAX_DISCOUNT', get_lookup_value('HR_NL_YES_NO','Y',userenv('lang'))||', '||
1401: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1402: fnd_date.date_to_chardate(r_wage_table_det.effectivefrom));
1403: Tag('WAGE_TABLE','_END_');
1404: l_wage_table_status := 'Y';
1405: l_emp_count1 := l_emp_count1+1;
1406: END IF;

Line 1413: fnd_date.date_to_chardate(r_wage_table_det.effectivefrom));

1409: l_temp_date_to := NVL(r_wage_table_det.effectiveto,hr_general.end_of_time);
1410: Tag('WAGE_TABLE','_START_');
1411: Tag('WAGE_TAX_DISCOUNT', get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1412: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1413: fnd_date.date_to_chardate(r_wage_table_det.effectivefrom));
1414: Tag('WAGE_TABLE','_END_');
1415: l_wage_table_status := 'N';
1416: l_emp_count1 := l_emp_count1+1;
1417: END IF;

Line 1434: fnd_date.date_to_chardate(l_temp_date_to+1));

1430: IF l_temp_date_to<> hr_general.end_of_time AND l_temp_date_to IS NOT NULL THEN
1431: Tag('LHD_TABLE','_START_');
1432: Tag('LABOUR_HANDICAP_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1433: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1434: fnd_date.date_to_chardate(l_temp_date_to+1));
1435: Tag('LHD_TABLE','_END_');
1436: END IF;
1437: IF l_temp_date_to IS NULL THEN
1438: Tag('LHD_TABLE','_START_');

Line 1449: fnd_date.date_to_chardate(l_temp_date_to+1));

1445: IF l_temp_date_to+1 1446: Tag('LHD_TABLE','_START_');
1447: Tag('LABOUR_HANDICAP_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1448: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1449: fnd_date.date_to_chardate(l_temp_date_to+1));
1450: Tag('LHD_TABLE','_END_');
1451: l_previous := 'N';
1452: END IF;
1453:

Line 1461: fnd_date.date_to_chardate(r_get_lhd_details.DATE_FROM));

1457: IF l_previous <> 'Y' THEN
1458: Tag('LHD_TABLE','_START_');
1459: Tag('LABOUR_HANDICAP_DISCOUNT',get_lookup_value('HR_NL_YES_NO','Y',userenv('lang'))||', '||
1460: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1461: fnd_date.date_to_chardate(r_get_lhd_details.DATE_FROM));
1462: Tag('LHD_TABLE','_END_');
1463: l_previous := 'Y';
1464: END IF;
1465:

Line 1481: fnd_date.date_to_chardate(l_temp_date_to+1));

1477: IF l_temp_date_to<> hr_general.end_of_time AND l_temp_date_to IS NOT NULL THEN
1478: Tag('TTD_TABLE','_START_');
1479: Tag('TEMP_TAX_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1480: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1481: fnd_date.date_to_chardate(l_temp_date_to+1));
1482: Tag('TTD_TABLE','_END_');
1483: END IF;
1484: IF l_temp_date_to IS NULL THEN
1485: Tag('TTD_TABLE','_START_');

Line 1497: fnd_date.date_to_chardate(l_temp_date_to+1));

1493: IF l_temp_date_to+1 1494: Tag('TTD_TABLE','_START_');
1495: Tag('TEMP_TAX_DISCOUNT',get_lookup_value('HR_NL_YES_NO','N',userenv('lang'))||', '||
1496: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1497: fnd_date.date_to_chardate(l_temp_date_to+1));
1498: Tag('TTD_TABLE','_END_');
1499: l_previous := 'N';
1500: END IF;
1501:

Line 1508: fnd_date.date_to_chardate(r_get_ttd_details.date_from));

1504: IF l_previous <> 'Y' THEN
1505: Tag('TTD_TABLE','_START_');
1506: Tag('TEMP_TAX_DISCOUNT',get_lookup_value('HR_NL_YES_NO','Y',userenv('lang'))||', '||
1507: get_lookup_value('NL_FORM_LABELS','COMMENCING_FROM',userenv('lang'))||' '||
1508: fnd_date.date_to_chardate(r_get_ttd_details.date_from));
1509: Tag('TTD_TABLE','_END_');
1510: l_previous := 'Y';
1511: END IF;
1512: END LOOP;

Line 1949: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');

1945:
1946: BEGIN
1947:
1948: --Get Start and End date of year
1949: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1950: l_reporting_end_date := fnd_date.canonical_to_date(p_end_of_year);
1951:
1952: --Open Cursor to fetch Employee Details in Organization
1953: <>

Line 1950: l_reporting_end_date := fnd_date.canonical_to_date(p_end_of_year);

1946: BEGIN
1947:
1948: --Get Start and End date of year
1949: l_reporting_start_date := TRUNC(fnd_date.canonical_to_date(p_end_of_year),'Y');
1950: l_reporting_end_date := fnd_date.canonical_to_date(p_end_of_year);
1951:
1952: --Open Cursor to fetch Employee Details in Organization
1953: <>
1954: FOR r_person_details IN csr_person_details