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.PER_NL_FDR_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 244: and EXISTS (SELECT 1 FROM hr_organization_information hoi1

240:
241: select 1 INTO l_return_val
242: from hr_organization_units hou
243: where hou.organization_id = p_org_id
244: and EXISTS (SELECT 1 FROM hr_organization_information hoi1
245:
246: WHERE hoi1.org_information_context= 'NL_ORG_INFORMATION'
247: AND hoi1.organization_id=hou.organization_id
248: AND hoi1.org_information4 IS NOT NULL

Line 253: SELECT 1 FROM hr_organization_information hoi2

249: AND hoi1.org_information3 IS NOT NULL
250:
251: UNION
252:
253: SELECT 1 FROM hr_organization_information hoi2
254:
255: WHERE hoi2.org_information_context= 'NL_LE_TAX_DETAILS'
256: AND hoi2.organization_id=hou.organization_id
257: AND hoi2.org_information1 IS NOT NULL

Line 501: AND EXISTS (SELECT 1 FROM HR_ALL_ORGANIZATION_UNITS HOU1, HR_ORGANIZATION_INFORMATION HOI1

497: select 1 INTO l_return_val
498: from hr_organization_units hou
499: WHERE HOU.BUSINESS_GROUP_ID = p_bg_id
500: AND HOU.organization_id = p_org_id
501: AND EXISTS (SELECT 1 FROM HR_ALL_ORGANIZATION_UNITS HOU1, HR_ORGANIZATION_INFORMATION HOI1
502: WHERE HOU1.BUSINESS_GROUP_ID = p_bg_id
503: AND HOI1.ORG_INFORMATION_CONTEXT = 'NL_LE_TAX_DETAILS'
504: AND HOI1.ORG_INFORMATION1 IS NOT NULL
505: AND HOI1.ORG_INFORMATION2 IS NOT NULL

Line 511: SELECT 1 FROM HR_ALL_ORGANIZATION_UNITS HOU2, HR_ORGANIZATION_INFORMATION HOI2

507: AND HOU1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
508:
509: UNION
510:
511: SELECT 1 FROM HR_ALL_ORGANIZATION_UNITS HOU2, HR_ORGANIZATION_INFORMATION HOI2
512: WHERE HOU2.BUSINESS_GROUP_ID = p_bg_id
513: AND HOI2.ORG_INFORMATION_CONTEXT = 'NL_ORG_INFORMATION'
514: AND HOI2.ORG_INFORMATION4 IS NOT NULL
515: AND HOI2.ORG_INFORMATION3 IS NOT NULL

Line 541: AND EXISTS (SELECT 1 FROM hr_organization_units hou1, hr_organization_information hoi1

537: SELECT 1 INTO l_return_val
538: FROM hr_organization_units hou
539: WHERE hou.organization_id = p_org_id
540: AND hou.business_group_id = p_bg_id
541: AND EXISTS (SELECT 1 FROM hr_organization_units hou1, hr_organization_information hoi1
542:
543: WHERE hoi1.org_information_context= 'NL_ORG_INFORMATION'
544: AND hou1.business_group_id=p_bg_id
545: AND hou1.organization_id=hou.organization_id

Line 567: SELECT 1 FROM hr_organization_units hou2, hr_organization_information hoi2

563: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
564:
565: UNION
566:
567: SELECT 1 FROM hr_organization_units hou2, hr_organization_information hoi2
568:
569: WHERE hoi2.org_information_context= 'NL_LE_TAX_DETAILS'
570: AND hou2.business_group_id=p_bg_id
571: AND hou2.organization_id=hou.organization_id

Line 934: hr_organization_information hoi,

930: from pay_assignment_actions paa,
931: per_all_assignments_f pas,
932: per_assignment_status_types past,
933: hr_organization_units hou,
934: hr_organization_information hoi,
935: per_org_structure_versions posv
936:
937: where posv.organization_structure_id=p_org_struct_id
938: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)

Line 959: hr_organization_information hoi

955: from pay_assignment_actions paa,
956: per_all_assignments_f pas,
957: per_assignment_status_types past,
958: hr_organization_units hou,
959: hr_organization_information hoi
960:
961: where paa.assignment_action_id = p_assignment_action_id
962: and pas.assignment_id = paa.assignment_id
963: and past.assignment_status_type_id = pas.assignment_status_type_id