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_US_IPEDS_PKG dependencies on FND_DATE

Line 226: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

222: AND peo.person_id = ppea.person_id
223: AND peo.person_id = ppet.person_id
224: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
225: AND ppet.information_type = 'PQH_TENURE_STATUS'
226: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
227: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
228: AND ppea.pei_information1 IS NOT NULL
229: AND ppet.pei_information1 IN ('01','02','04')
230: AND peo.current_employee_flag = 'Y'

Line 227: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130

223: AND peo.person_id = ppet.person_id
224: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
225: AND ppet.information_type = 'PQH_TENURE_STATUS'
226: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
227: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
228: AND ppea.pei_information1 IS NOT NULL
229: AND ppet.pei_information1 IN ('01','02','04')
230: AND peo.current_employee_flag = 'Y'
231: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 348: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

344: AND peo.person_id = ppea.person_id
345: AND peo.person_id = ppet.person_id
346: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
347: AND ppet.information_type = 'PQH_TENURE_STATUS'
348: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
349: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
350: AND ppea.pei_information1 IS NOT NULL
351: AND ppet.pei_information1 IN ('03','05')
352: AND peo.current_employee_flag = 'Y'

Line 349: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130

345: AND peo.person_id = ppet.person_id
346: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
347: AND ppet.information_type = 'PQH_TENURE_STATUS'
348: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
349: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
350: AND ppea.pei_information1 IS NOT NULL
351: AND ppet.pei_information1 IN ('03','05')
352: AND peo.current_employee_flag = 'Y'
353: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 586: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

582: ,per_shared_types pst1
583: WHERE peo.person_id = asg.person_id
584: AND peo.person_id = ppea.person_id
585: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
586: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
587: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
588: AND ppea.pei_information1 IS NOT NULL
589: AND peo.current_employee_flag = 'Y'
590: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 587: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130

583: WHERE peo.person_id = asg.person_id
584: AND peo.person_id = ppea.person_id
585: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
586: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
587: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
588: AND ppea.pei_information1 IS NOT NULL
589: AND peo.current_employee_flag = 'Y'
590: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
591: AND job.business_group_id = p_business_group_id

Line 1540: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)

1536: ,per_shared_types pst1
1537: WHERE peo.person_id = asg.person_id
1538: AND peo.person_id = ppea.person_id
1539: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
1540: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
1541: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
1542: AND ppea.pei_information1 IS NOT NULL
1543: AND peo.current_employee_flag = 'Y'
1544: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'

Line 1541: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130

1537: WHERE peo.person_id = asg.person_id
1538: AND peo.person_id = ppea.person_id
1539: AND ppea.information_type = 'PQH_ACADEMIC_RANK'
1540: AND p_report_date BETWEEN fnd_date.canonical_to_date(ppea.PEI_INFORMATION2)
1541: and nvl(fnd_date.canonical_to_date(ppea.PEI_INFORMATION3),p_report_date) --16208130
1542: AND ppea.pei_information1 IS NOT NULL
1543: AND peo.current_employee_flag = 'Y'
1544: AND pqh_employment_category.identify_empl_category(asg.employment_category,l_fr,l_ft,l_pr,l_pt) = 'FR'
1545: AND pqh_employment_category.get_duration_in_months(pco.duration,pco.duration_units,pco.business_group_id,p_report_date) BETWEEN l_duration1 AND l_duration2