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_WTS_REPORT dependencies on HR_NL_ORG_INFO

Line 266: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))

262: CONNECT BY prior organization_id_child = organization_id_parent )
263: union
264: (select nvl(p_top_org_id,p_bg_id) from dual))
265: and pap.person_id=nvl(p_person_id,pap.person_id)
266: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
267: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
268: not null
269: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
270: and hou.business_group_id=p_bg_id

Line 267: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is

263: union
264: (select nvl(p_top_org_id,p_bg_id) from dual))
265: and pap.person_id=nvl(p_person_id,pap.person_id)
266: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
267: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
268: not null
269: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
270: and hou.business_group_id=p_bg_id
271: and hou1.organization_id = hoi.org_information3

Line 272: and hou.organization_id=hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)

268: not null
269: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
270: and hou.business_group_id=p_bg_id
271: and hou1.organization_id = hoi.org_information3
272: and hou.organization_id=hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)
273: and hoi.organization_id=hou.organization_id
274: and hoi.org_information3 IS NOT NULL
275: and hoi.org_information4 IS NOT NULL
276: and hoi.org_information_context='NL_ORG_INFORMATION'

Line 799: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))

795: CONNECT BY prior organization_id_child = organization_id_parent )
796: union
797: (select nvl(p_top_org_id,p_bg_id) from dual))
798: and pap.person_id=nvl(p_person_id,pap.person_id)
799: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
800: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
801: not null
802: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
803: and hou.business_group_id=p_bg_id

Line 800: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is

796: union
797: (select nvl(p_top_org_id,p_bg_id) from dual))
798: and pap.person_id=nvl(p_person_id,pap.person_id)
799: and ((p_top_org_id is NULL) or (nvl(p_inc_sub_emp,'N') = 'N' and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)=p_top_org_id) or (nvl(p_inc_sub_emp,'N') = 'Y'))
800: and hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id) is
801: not null
802: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
803: and hou.business_group_id=p_bg_id
804: and hou1.organization_id = hoi.org_information3

Line 805: and hou.organization_id=hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)

801: not null
802: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
803: and hou.business_group_id=p_bg_id
804: and hou1.organization_id = hoi.org_information3
805: and hou.organization_id=hr_nl_org_info.get_tax_org_id(GET_ORG_STRUCT_VERSION_ID(p_org_struct_id,p_month_to),paa.organization_id)
806: and hoi.organization_id=hou.organization_id
807: and hoi.org_information3 IS NOT NULL
808: and hoi.org_information4 IS NOT NULL
809: and hoi.org_information_context='NL_ORG_INFORMATION'