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_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

Line 1534: AND NVL(posv.date_to,hr_general.end_of_time);

1530: SELECT org_structure_version_id
1531: FROM per_org_structure_versions posv
1532: WHERE organization_structure_id =p_org_struct_id
1533: AND p_date_earned BETWEEN posv.date_from
1534: AND NVL(posv.date_to,hr_general.end_of_time);
1535:
1536:
1537: --
1538: --

Line 1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'

1710: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_meaning'||l_meaning,1440);
1711: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_code'||l_tax_code,1440);
1712: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS p_assignment_id'||p_assignment_id,1440);
1713:
1714: l_meaning:= hr_general.decode_lookup('NL_TAX_CODE'
1715: ,substr(l_tax_code,1,3));
1716:
1717: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_ni'||l_ni,1440);
1718:

Line 1722: l_ni:= hr_general.decode_lookup('NL_TAX_TYPE'

1718:
1719: IF l_meaning is null THEN
1720: -- Split the tax code
1721: -- 1st Digit
1722: l_ni:= hr_general.decode_lookup('NL_TAX_TYPE'
1723: ,substr(l_tax_code,1,1));
1724:
1725: -- 2nd Digit
1726: l_table:= hr_general.decode_lookup('NL_TAX_TABLE'

Line 1726: l_table:= hr_general.decode_lookup('NL_TAX_TABLE'

1722: l_ni:= hr_general.decode_lookup('NL_TAX_TYPE'
1723: ,substr(l_tax_code,1,1));
1724:
1725: -- 2nd Digit
1726: l_table:= hr_general.decode_lookup('NL_TAX_TABLE'
1727: ,substr(l_tax_code,2,1));
1728:
1729: -- 3rd Digit
1730: l_period:= hr_general.decode_lookup('NL_PAYROLL_PERIOD'

Line 1730: l_period:= hr_general.decode_lookup('NL_PAYROLL_PERIOD'

1726: l_table:= hr_general.decode_lookup('NL_TAX_TABLE'
1727: ,substr(l_tax_code,2,1));
1728:
1729: -- 3rd Digit
1730: l_period:= hr_general.decode_lookup('NL_PAYROLL_PERIOD'
1731: ,substr(l_tax_code,3,1));
1732:
1733: END IF;
1734: ELSE

Line 1768: l_tax_reduction :=hr_general.decode_lookup('HR_NL_REPORT_LABELS'

1764: IF l_tax_reduction = 'Y' THEN
1765:
1766: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_age'||l_age,1440);
1767: IF l_age < 65 THEN
1768: l_tax_reduction :=hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1769: ,'NL_GENERAL');
1770: ELSE
1771: l_tax_reduction:= hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1772: ,'NL_SENIOR');

Line 1771: l_tax_reduction:= hr_general.decode_lookup('HR_NL_REPORT_LABELS'

1767: IF l_age < 65 THEN
1768: l_tax_reduction :=hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1769: ,'NL_GENERAL');
1770: ELSE
1771: l_tax_reduction:= hr_general.decode_lookup('HR_NL_REPORT_LABELS'
1772: ,'NL_SENIOR');
1773: END IF;
1774:
1775: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_tax_reduction'||l_tax_reduction,1440);

Line 1945: l_city:= hr_general.decode_lookup('HR_NL_CITY',csr_hr_org_address_rec.city);

1941: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_regular_working_hours'||' '||l_regular_working_hours);
1942: -- Archive ADDL EMPLOYEE DETAILS
1943: --
1944:
1945: l_city:= hr_general.decode_lookup('HR_NL_CITY',csr_hr_org_address_rec.city);
1946:
1947: l_province:= hr_general.decode_lookup('HR_NL_PROVINCE',csr_hr_org_address_rec.province);
1948:
1949: l_country:=get_country_name(csr_hr_org_address_rec.country);

Line 1947: l_province:= hr_general.decode_lookup('HR_NL_PROVINCE',csr_hr_org_address_rec.province);

1943: --
1944:
1945: l_city:= hr_general.decode_lookup('HR_NL_CITY',csr_hr_org_address_rec.city);
1946:
1947: l_province:= hr_general.decode_lookup('HR_NL_PROVINCE',csr_hr_org_address_rec.province);
1948:
1949: l_country:=get_country_name(csr_hr_org_address_rec.country);
1950:
1951: l_street_name:=csr_hr_org_address_rec.street_name;

Line 1955: l_street_name:= hr_general.decode_lookup('NL_REGION',csr_hr_org_address_rec.street_name);

1951: l_street_name:=csr_hr_org_address_rec.street_name;
1952:
1953: IF csr_hr_org_address_rec.style = 'NL_GLB' THEN
1954:
1955: l_street_name:= hr_general.decode_lookup('NL_REGION',csr_hr_org_address_rec.street_name);
1956:
1957: END IF;
1958:
1959: /*OPEN csr_get_territory_name(csr_hr_org_address_rec.country);

Line 4159: l_balance_name :=hr_general.decode_lookup(

4155:
4156: OPEN csr_get_translated_bal_name (p_balance_name);
4157: FETCH csr_get_translated_bal_name INTO l_balance_name;
4158: IF csr_get_translated_bal_name%NOTFOUND THEN
4159: l_balance_name :=hr_general.decode_lookup(
4160: 'HR_NL_REPORT_LABELS',UPPER(p_balance_name));
4161: END IF;
4162: CLOSE csr_get_translated_bal_name;
4163: END LOOP;

Line 4403: l_balance_name :=hr_general.decode_lookup(

4399: --
4400: OPEN csr_get_translated_bal_name (p_balance_name);
4401: FETCH csr_get_translated_bal_name INTO l_balance_name;
4402: IF csr_get_translated_bal_name%NOTFOUND THEN
4403: l_balance_name :=hr_general.decode_lookup(
4404: 'HR_NL_REPORT_LABELS',UPPER(p_balance_name));
4405: END IF;
4406: CLOSE csr_get_translated_bal_name;
4407:

Line 5000: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));

4996:
4997: OPEN csr_get_translated_bal_name (p_balance_name);
4998: FETCH csr_get_translated_bal_name INTO l_balance_name;
4999: IF csr_get_translated_bal_name%NOTFOUND THEN
5000: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));
5001: END IF;
5002: CLOSE csr_get_translated_bal_name;
5003:
5004: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);

Line 5368: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));

5364:
5365: OPEN csr_get_translated_bal_name (p_balance_name);
5366: FETCH csr_get_translated_bal_name INTO l_balance_name;
5367: IF csr_get_translated_bal_name%NOTFOUND THEN
5368: l_balance_name :=hr_general.decode_lookup('HR_NL_REPORT_LABELS',UPPER(p_balance_name));
5369: END IF;
5370: CLOSE csr_get_translated_bal_name;
5371: --hr_utility.set_location('Inside archive_retro_balance_info non context l_balance_name'||l_balance_name,6250);
5372: