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 268: 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'))

264: CONNECT BY prior organization_id_child = organization_id_parent )
265: union
266: (select nvl(p_top_org_id,p_bg_id) from dual))
267: and pap.person_id=nvl(p_person_id,pap.person_id)
268: 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'))
269: 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
270: not null
271: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
272: and hou.business_group_id=p_bg_id

Line 269: 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

265: union
266: (select nvl(p_top_org_id,p_bg_id) from dual))
267: and pap.person_id=nvl(p_person_id,pap.person_id)
268: 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'))
269: 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
270: not null
271: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
272: and hou.business_group_id=p_bg_id
273: and hou1.organization_id = hoi.org_information3

Line 274: 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)

270: not null
271: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
272: and hou.business_group_id=p_bg_id
273: and hou1.organization_id = hoi.org_information3
274: 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)
275: and hoi.organization_id=hou.organization_id
276: and hoi.org_information3 IS NOT NULL
277: and hoi.org_information4 IS NOT NULL
278: and hoi.org_information_context='NL_ORG_INFORMATION'

Line 868: 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'))

864: CONNECT BY prior organization_id_child = organization_id_parent )
865: union
866: (select nvl(p_top_org_id,p_bg_id) from dual))
867: and pap.person_id=nvl(p_person_id,pap.person_id)
868: 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'))
869: 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
870: not null
871: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
872: and hou.business_group_id=p_bg_id

Line 869: 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

865: union
866: (select nvl(p_top_org_id,p_bg_id) from dual))
867: and pap.person_id=nvl(p_person_id,pap.person_id)
868: 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'))
869: 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
870: not null
871: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
872: and hou.business_group_id=p_bg_id
873: and hou1.organization_id = hoi.org_information3

Line 874: 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)

870: not null
871: and LAST_DAY(to_date(P_MONTH_TO,'MMYYYY')) between pap.effective_start_date and pap.effective_end_date
872: and hou.business_group_id=p_bg_id
873: and hou1.organization_id = hoi.org_information3
874: 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)
875: and hoi.organization_id=hou.organization_id
876: and hoi.org_information3 IS NOT NULL
877: and hoi.org_information4 IS NOT NULL
878: and hoi.org_information_context='NL_ORG_INFORMATION'