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 96: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)

92: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start
93:
94: )
95: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
96: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)
97: and paa.person_id = pap.person_id
98: and pap.business_group_id = p_bg_id
99: and paa.business_group_id = p_bg_id
100: and hou.organization_id = p_employer_id

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

110: where pos.organization_structure_id = posv.organization_structure_id
111: and to_char(pos.organization_structure_id) IN (select org_information1
112: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
113: and hoi.organization_id=lp_business_group_id)
114: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
115:
116: CURSOR csr_get_org_name(lp_org_id number) IS
117: select name
118: from hr_organization_units

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

125:
126: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS
127: select hlc.loc_information14 house_number,
128: hlc.loc_information15 house_no_add,
129: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,
130: hlc.address_line_1 address_line1,
131: hlc.address_line_2 address_line2,
132: hlc.address_line_3 address_line3,
133: hlc.postal_code postcode,

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

142:
143: CURSOR csr_emp_glb_address(p_person_id NUMBER, p_effective_date DATE) IS
144: select pad.add_information13 house_number,
145: pad.add_information14 house_no_add,
146: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,
147: pad.address_line1 address_line1,
148: pad.address_line2 address_line2,
149: pad.address_line3 address_line3,
150: pad.postal_code postcode,

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

152: pay_nl_general.get_country_name(pad.country) country,
153: pad.style add_style
154: from per_addresses pad
155: where pad.person_id = p_person_id
156: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
157: and pad.primary_flag = 'Y';
158:
159: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
160: select hou.organization_id leg_emp_id,

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

277:
278: l_effective_date := fnd_date.canonical_to_date(p_year);
279: l_year := to_char(l_effective_date,'YYYY');
280: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
283:
284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

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

278: l_effective_date := fnd_date.canonical_to_date(p_year);
279: l_year := to_char(l_effective_date,'YYYY');
280: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
281: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
282: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
283:
284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
286:

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

284: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
285: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
286:
287: if p_agg_flag = 'Y' THEN
288: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
289: else
290: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
291: end if;
292:

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

286:
287: if p_agg_flag = 'Y' THEN
288: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
289: else
290: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
291: end if;
292:
293: BEGIN
294:

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

1061: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Company_Car;
1062: vCtr := vCtr + 1;*/
1063:
1064: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
1065: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
1066: vCtr := vCtr + 1;
1067:
1068: end if;
1069:

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

1437: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Private_Use_Car;
1438: vCtr := vCtr + 1;
1439:
1440: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
1441: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
1442: vCtr := vCtr + 1;
1443:
1444: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Value_Private_Use_Car';
1445: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Value_Private_Use_Car;

Line 1637: 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,

1633: ppos.date_start Date_Start,
1634: nvl(ppos.actual_termination_date,lp_tax_year_end_date) Date_End,
1635: 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,
1636: pap.national_identifier SOFI_number,
1637: 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,
1638: decode(substr(pai.action_information9,1,1),'1',lp_yes,lp_no) Wage_Tax_Discount1,
1639: '(' || substr(pai.action_information9,2,2)||'/'||substr(pai.action_information9,4,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date1,
1640: decode(substr(pai.action_information9,6,1),'1',lp_yes,lp_no) Wage_Tax_Discount2,
1641: '(' || substr(pai.action_information9,7,2)||'/'||substr(pai.action_information9,9,2)||'/'||to_char(lp_tax_year_end_date,'YYYY') || ')' Date2,

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

1689: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= ppos.date_start
1690:
1691: )
1692: and lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
1693: and lp_Tax_Year_End_Date between hou.date_from and nvl(hou.date_to,hr_general.end_of_time)
1694: and paa.person_id = pap.person_id
1695: and pap.business_group_id = p_bg_id
1696: and paa.business_group_id = p_bg_id
1697: and hou.organization_id = p_employer_id

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

1707: where pos.organization_structure_id = posv.organization_structure_id
1708: and to_char(pos.organization_structure_id) IN (select org_information1
1709: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1710: and hoi.organization_id=lp_business_group_id)
1711: and lp_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);*/
1712:
1713: CURSOR csr_get_org_name(lp_org_id number) IS
1714: select name
1715: from hr_organization_units

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

1722:
1723: CURSOR csr_org_glb_address(p_bg_id NUMBER, p_org_id NUMBER) IS
1724: select hlc.loc_information14 house_number,
1725: hlc.loc_information15 house_no_add,
1726: hr_general.decode_lookup('NL_REGION',hlc.region_1) street_name,
1727: hlc.address_line_1 address_line1,
1728: hlc.address_line_2 address_line2,
1729: hlc.address_line_3 address_line3,
1730: hlc.postal_code postcode,

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

1739:
1740: CURSOR csr_emp_glb_address(p_person_id NUMBER, p_effective_date DATE) IS
1741: select pad.add_information13 house_number,
1742: pad.add_information14 house_no_add,
1743: hr_general.decode_lookup('NL_REGION',pad.region_1) street_name,
1744: pad.address_line1 address_line1,
1745: pad.address_line2 address_line2,
1746: pad.address_line3 address_line3,
1747: pad.postal_code postcode,

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

1749: pay_nl_general.get_country_name(pad.country) country,
1750: pad.style add_style
1751: from per_addresses pad
1752: where pad.person_id = p_person_id
1753: and p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time)
1754: and pad.primary_flag = 'Y';
1755:
1756: CURSOR csr_get_leg_employer(p_assignment_id NUMBER, p_tax_year_start_date DATE, p_tax_year_end_date DATE) IS
1757: select hou.organization_id leg_emp_id,

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

1874:
1875: l_effective_date := fnd_date.canonical_to_date(p_year);
1876: l_year := to_char(l_effective_date,'YYYY');
1877: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1880:
1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);

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

1875: l_effective_date := fnd_date.canonical_to_date(p_year);
1876: l_year := to_char(l_effective_date,'YYYY');
1877: l_tax_year_start_date := to_date('01-01-'||l_year,'DD-MM-YYYY');
1878: l_yes :=hr_general.decode_lookup('HR_NL_YES_NO','Y');
1879: l_no :=hr_general.decode_lookup('HR_NL_YES_NO','N');
1880:
1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1883:

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

1881: PAY_NL_TAXOFFICE_ARCHIVE.populate_UserBal(p_bg_id,l_effective_date);
1882: hr_utility.set_location('Table populated, count-'||PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.COUNT,10);
1883:
1884: if p_agg_flag = 'Y' THEN
1885: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1886: else
1887: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
1888: end if;
1889:

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

1883:
1884: if p_agg_flag = 'Y' THEN
1885: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','Y');
1886: else
1887: l_agg_flag := hr_general.decode_lookup('HR_NL_YES_NO','N');
1888: end if;
1889:
1890: BEGIN
1891:

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

2658: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Company_Car;
2659: vCtr := vCtr + 1;*/
2660:
2661: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
2662: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
2663: vCtr := vCtr + 1;
2664:
2665: end if;
2666:

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

3034: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Private_Use_Car;
3035: vCtr := vCtr + 1;
3036:
3037: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Code_Reason_No';
3038: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('NL_COMPANY_CAR_USAGE_CODE',info_rec.Company_Car);
3039: vCtr := vCtr + 1;
3040:
3041: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'Value_Private_Use_Car';
3042: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := info_rec.Value_Private_Use_Car;

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

3314: SELECT pad.style INTO l_address_style
3315: FROM per_addresses pad
3316: WHERE pad.person_id = p_person_id
3317: AND pad.primary_flag = 'Y'
3318: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3319:
3320: EXCEPTION
3321:
3322: WHEN NO_DATA_FOUND

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

3349: SELECT pad.postal_code INTO l_post_code
3350: FROM per_addresses pad
3351: WHERE pad.person_id = p_person_id
3352: AND pad.primary_flag = 'Y'
3353: AND p_effective_date between pad.date_from and nvl(pad.date_to,hr_general.end_of_time);
3354:
3355: EXCEPTION
3356:
3357: WHEN NO_DATA_FOUND