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 HR_GENERAL

Line 839: ,hr_general.decode_lookup ('HR_NL_CITY'

835: ,substr (hlc.postal_code
836: ,5
837: ,2)))
838: ,hlc.postal_code) postcode
839: ,hr_general.decode_lookup ('HR_NL_CITY'
840: ,hlc.town_or_city) city
841: ,hlc.country country
842: FROM hr_locations hlc
843: ,hr_organization_units hou

Line 865: ,hr_general.decode_lookup ('HR_NL_CITY'

861: ,substr (pad.postal_code
862: ,5
863: ,2)))
864: ,pad.postal_code) postcode
865: ,hr_general.decode_lookup ('HR_NL_CITY'
866: ,pad.town_or_city) city
867: ,pad.country country
868: FROM per_addresses pad
869: WHERE pad.person_id = c_person_id

Line 872: ,hr_general.end_of_time)

868: FROM per_addresses pad
869: WHERE pad.person_id = c_person_id
870: AND l_reporting_date BETWEEN date_from
871: AND nvl (date_to
872: ,hr_general.end_of_time)
873: AND pad.primary_flag = 'Y';
874: --=============================================================================
875: /***********************************************************
876: Cursor to get Organization Structure Version id

Line 884: ,hr_general.end_of_time);

880: FROM per_org_structure_versions posv
881: WHERE organization_structure_id = c_org_struct_id
882: AND l_reporting_date BETWEEN posv.date_from
883: AND nvl (posv.date_to
884: ,hr_general.end_of_time);
885: --=============================================================================
886:
887: /***********************************************************
888: Cursor to get Employer Details

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 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 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

1367: LOOP
1368: FETCH cur_wage_table_det INTO r_wage_table_det;
1369:
1370: IF cur_wage_table_det%notfound THEN
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));

Line 1398: l_temp_date_to := NVL(r_wage_table_det.effectiveto,hr_general.end_of_time);

1394: l_emp_count1 := l_emp_count1+1;
1395: END IF;
1396:
1397: IF r_wage_table_det.wagetaxdiscount = 'Y' AND l_wage_table_status<>'Y' THEN
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));

Line 1409: l_temp_date_to := NVL(r_wage_table_det.effectiveto,hr_general.end_of_time);

1405: l_emp_count1 := l_emp_count1+1;
1406: END IF;
1407:
1408: IF r_wage_table_det.effectivefrom IS NOT NULL AND r_wage_table_det.wagetaxdiscount='N' AND l_wage_table_status<>'N' AND l_emp_count1>0 THEN
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));

Line 1430: IF l_temp_date_to<> hr_general.end_of_time AND l_temp_date_to IS NOT NULL THEN

1426: LOOP
1427: FETCH cur_get_lhd_details INTO r_get_lhd_details;
1428:
1429: IF cur_get_lhd_details%notfound THEN
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));

Line 1455: l_temp_date_to := NVL(r_get_lhd_details.DATE_TO,hr_general.end_of_time);

1451: l_previous := 'N';
1452: END IF;
1453:
1454:
1455: l_temp_date_to := NVL(r_get_lhd_details.DATE_TO,hr_general.end_of_time);
1456:
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'))||', '||

Line 1477: IF l_temp_date_to<> hr_general.end_of_time AND l_temp_date_to IS NOT NULL THEN

1473: LOOP
1474: FETCH cur_get_ttd_details INTO r_get_ttd_details;
1475:
1476: IF cur_get_ttd_details%NOTFOUND THEN
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));

Line 1502: l_temp_date_to := NVL(r_get_ttd_details.DATE_TO,hr_general.end_of_time);

1498: Tag('TTD_TABLE','_END_');
1499: l_previous := 'N';
1500: END IF;
1501:
1502: l_temp_date_to := NVL(r_get_ttd_details.DATE_TO,hr_general.end_of_time);
1503:
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'))||', '||

Line 1968: IF NVL(r_other_emp_details.end_date,hr_general.end_of_time)<>hr_general.end_of_time THEN

1964: t_single_personid_details(l_per_index).employee_number := r_other_emp_details.employee_number;
1965: t_single_personid_details(l_per_index).employee_name := r_other_emp_details.employee_name;
1966: t_single_personid_details(l_per_index).sofi_number := r_other_emp_details.sofi_number;
1967: t_single_personid_details(l_per_index).hire_date := r_other_emp_details.hire_date;
1968: IF NVL(r_other_emp_details.end_date,hr_general.end_of_time)<>hr_general.end_of_time THEN
1969: t_single_personid_details(l_per_index).end_date := r_other_emp_details.end_date;
1970: END IF;
1971: t_single_personid_details(l_per_index).income := l_wage_tax_income;
1972: t_single_personid_details(l_per_index).tax := (l_wage_tax_income-p_threshold_limit)*p_percentage/100;

Line 1992: IF NVL(r_other_emp_details.end_date,hr_general.end_of_time)<>hr_general.end_of_time THEN

1988: t_individual_person_details(i).employee_name := r_other_emp_details.employee_name;
1989: t_individual_person_details(i).employer_name := r_other_emp_details.employer_name;
1990: t_individual_person_details(i).sofi_number := r_other_emp_details.sofi_number;
1991: t_individual_person_details(i).hire_date := r_other_emp_details.hire_date;
1992: IF NVL(r_other_emp_details.end_date,hr_general.end_of_time)<>hr_general.end_of_time THEN
1993: t_individual_person_details(i).end_date := r_other_emp_details.end_date;
1994: END IF;
1995: t_individual_person_details(i).income := l_wage_tax_income;
1996: i := i+1;