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

Line 40: DECODE(SUBSTR(pai.action_information10,2,1),1,hr_general.decode_lookup('NL_TAX_TABLE','1'),2,hr_general.decode_lookup('NL_TAX_TABLE','2'),'') Wage_Tax_Table,

36: ppos.date_start Date_Start,
37: nvl(ppos.actual_termination_date,lp_tax_year_end_date) Date_End,
38: to_char(greatest(ppos.date_start,lp_tax_year_start_date),'DD/MM/YYYY')||' - '||to_char(least(nvl(ppos.actual_termination_date,lp_tax_year_end_date),lp_tax_year_end_date),'DD/MM/YYYY') Period_Of_Service,
39: pap.national_identifier SOFI_number,
40: DECODE(SUBSTR(pai.action_information10,2,1),1,hr_general.decode_lookup('NL_TAX_TABLE','1'),2,hr_general.decode_lookup('NL_TAX_TABLE','2'),'') Wage_Tax_Table,
41: decode(substr(pai.action_information9,1,1),'1',lp_yes,lp_no) Wage_Tax_Discount1,
42: '(' || substr(pai.action_information9,2,2)||'/'||substr(pai.action_information9,4,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date1,
43: decode(substr(pai.action_information9,6,1),'1',lp_yes,lp_no) Wage_Tax_Discount2,
44: '(' || substr(pai.action_information9,7,2)||'/'||substr(pai.action_information9,9,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date2,

Line 112: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)

108: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start
109:
110: )
111: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
112: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)
113: and paa.person_id = pap.person_id
114: and pap.business_group_id = p_bg_id
115: and paa.business_group_id = p_bg_id
116: and hou.organization_id = p_employer_id

Line 130: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/

126: where pos.organization_structure_id = posv.organization_structure_id
127: and to_char(pos.organization_structure_id) IN (select org_information1
128: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
129: and hoi.organization_id=lp_business_group_id)
130: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
131:
132: CURSOR csr_get_org_name(lp_org_id number) IS
133: select name
134: from hr_organization_units

Line 145: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,

141:
142: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS
143: select hlc.loc_information14 house_number,
144: hlc.loc_information15 house_no_add,
145: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,
146: hlc.address_line_1 address_line1,
147: hlc.address_line_2 address_line2,
148: hlc.address_line_3 address_line3,
149: hlc.postal_code postcode,

Line 162: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,

158:
159: CURSOR csr_emp_glb_address(p_person_id NUMBER, p_effective_date DATE) IS
160: select pad.add_information13 house_number,
161: pad.add_information14 house_no_add,
162: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,
163: pad.address_line1 address_line1,
164: pad.address_line2 address_line2,
165: pad.address_line3 address_line3,
166: pad.postal_code postcode,

Line 172: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)

168: pay_nl_general.get_country_name(pad.country) country,
169: pad.style add_style
170: from per_addresses pad
171: where pad.person_id = p_person_id
172: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
173: and pad.primary_flag = 'Y';
174:
175: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
176: select hou.organization_id leg_emp_id,

Line 297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');

293:
294: l_effective_date := fnd_date.canonical_to_date(p_year);
295: l_year := to_char(l_effective_date,'YYYY');
296: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
299:
300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

Line 298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

294: l_effective_date := fnd_date.canonical_to_date(p_year);
295: l_year := to_char(l_effective_date,'YYYY');
296: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
297: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
298: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
299:
300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
302:

Line 304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

300: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
301: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
302:
303: if p_agg_flag = 'Y' THEN
304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
305: else
306: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
307: end if;
308:

Line 306: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');

302:
303: if p_agg_flag = 'Y' THEN
304: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
305: else
306: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
307: end if;
308:
309: BEGIN
310:

Line 1086: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);

1082: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Company_Car;
1083: vCtr := vCtr + 1;*/
1084:
1085: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
1086: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
1087: vCtr := vCtr + 1;
1088:
1089: end if;
1090:

Line 1467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);

1463: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Private_Use_Car;
1464: vCtr := vCtr + 1;
1465:
1466: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
1467: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
1468: vCtr := vCtr + 1;
1469:
1470: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Value_Private_Use_Car';
1471: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Value_Private_Use_Car;

Line 1668: DECODE(SUBSTR(pai.action_information10,2,1),1,hr_general.decode_lookup('NL_TAX_TABLE','1'),2,hr_general.decode_lookup('NL_TAX_TABLE','2'),'') Wage_Tax_Table,

1664: ppos.date_start Date_Start,
1665: nvl(ppos.actual_termination_date,lp_tax_year_end_date) Date_End,
1666: to_char(greatest(ppos.date_start,lp_tax_year_start_date),'DD/MM/YYYY')||' - '||to_char(least(nvl(ppos.actual_termination_date,lp_tax_year_end_date),lp_tax_year_end_date),'DD/MM/YYYY') Period_Of_Service,
1667: pap.national_identifier SOFI_number,
1668: DECODE(SUBSTR(pai.action_information10,2,1),1,hr_general.decode_lookup('NL_TAX_TABLE','1'),2,hr_general.decode_lookup('NL_TAX_TABLE','2'),'') Wage_Tax_Table,
1669: decode(substr(pai.action_information9,1,1),'1',lp_yes,lp_no) Wage_Tax_Discount1,
1670: '(' || substr(pai.action_information9,2,2)||'/'||substr(pai.action_information9,4,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date1,
1671: decode(substr(pai.action_information9,6,1),'1',lp_yes,lp_no) Wage_Tax_Discount2,
1672: '(' || substr(pai.action_information9,7,2)||'/'||substr(pai.action_information9,9,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date2,

Line 1740: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)

1736: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start
1737:
1738: )
1739: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
1740: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)
1741: and paa.person_id = pap.person_id
1742: and pap.business_group_id = p_bg_id
1743: and paa.business_group_id = p_bg_id
1744: and hou.organization_id = p_employer_id

Line 1758: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/

1754: where pos.organization_structure_id = posv.organization_structure_id
1755: and to_char(pos.organization_structure_id) IN (select org_information1
1756: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1757: and hoi.organization_id=lp_business_group_id)
1758: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
1759:
1760: CURSOR csr_get_org_name(lp_org_id number) IS
1761: select name
1762: from hr_organization_units

Line 1773: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,

1769:
1770: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS
1771: select hlc.loc_information14 house_number,
1772: hlc.loc_information15 house_no_add,
1773: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,
1774: hlc.address_line_1 address_line1,
1775: hlc.address_line_2 address_line2,
1776: hlc.address_line_3 address_line3,
1777: hlc.postal_code postcode,

Line 1790: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,

1786:
1787: CURSOR csr_emp_glb_address(p_person_id NUMBER, p_effective_date DATE) IS
1788: select pad.add_information13 house_number,
1789: pad.add_information14 house_no_add,
1790: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,
1791: pad.address_line1 address_line1,
1792: pad.address_line2 address_line2,
1793: pad.address_line3 address_line3,
1794: pad.postal_code postcode,

Line 1800: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)

1796: pay_nl_general.get_country_name(pad.country) country,
1797: pad.style add_style
1798: from per_addresses pad
1799: where pad.person_id = p_person_id
1800: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1801: and pad.primary_flag = 'Y';
1802:
1803: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
1804: select hou.organization_id leg_emp_id,

Line 1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');

1921:
1922: l_effective_date := fnd_date.canonical_to_date(p_year);
1923: l_year := to_char(l_effective_date,'YYYY');
1924: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1927:
1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

Line 1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');

1922: l_effective_date := fnd_date.canonical_to_date(p_year);
1923: l_year := to_char(l_effective_date,'YYYY');
1924: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1925: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1926: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1927:
1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1930:

Line 1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');

1928: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1929: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1930:
1931: if p_agg_flag = 'Y' THEN
1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1933: else
1934: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
1935: end if;
1936:

Line 1934: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');

1930:
1931: if p_agg_flag = 'Y' THEN
1932: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1933: else
1934: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
1935: end if;
1936:
1937: BEGIN
1938:

Line 2714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);

2710: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Company_Car;
2711: vCtr := vCtr + 1;*/
2712:
2713: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
2714: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
2715: vCtr := vCtr + 1;
2716:
2717: end if;
2718:

Line 3095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);

3091: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Private_Use_Car;
3092: vCtr := vCtr + 1;
3093:
3094: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
3095: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
3096: vCtr := vCtr + 1;
3097:
3098: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Value_Private_Use_Car';
3099: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Value_Private_Use_Car;

Line 3380: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);

3376: SELECT pad.style INTO l_address_style
3377: FROM per_addresses pad
3378: WHERE pad.person_id = p_person_id
3379: AND pad.primary_flag = 'Y'
3380: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3381:
3382: EXCEPTION
3383:
3384: WHEN NO_DATA_FOUND

Line 3415: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);

3411: SELECT pad.postal_code INTO l_post_code
3412: FROM per_addresses pad
3413: WHERE pad.person_id = p_person_id
3414: AND pad.primary_flag = 'Y'
3415: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3416:
3417: EXCEPTION
3418:
3419: WHEN NO_DATA_FOUND