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_IN_EOY_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 541: FROM hr_organization_information hoi_bank

537: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
538: ,hoi_bank.org_information4 Bank
539: ,hoi_challan.org_information3 Voucher_Num
540: ,hoi_challan.org_information11 DD_Cheque_Num
541: FROM hr_organization_information hoi_bank
542: ,hr_organization_information hoi_challan
543: WHERE hoi_bank.organization_id = p_gre_id
544: AND hoi_challan.organization_id = hoi_bank.organization_id
545: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'

Line 542: ,hr_organization_information hoi_challan

538: ,hoi_bank.org_information4 Bank
539: ,hoi_challan.org_information3 Voucher_Num
540: ,hoi_challan.org_information11 DD_Cheque_Num
541: FROM hr_organization_information hoi_bank
542: ,hr_organization_information hoi_challan
543: WHERE hoi_bank.organization_id = p_gre_id
544: AND hoi_challan.organization_id = hoi_bank.organization_id
545: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
546: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'

Line 556: FROM hr_organization_information hoi_challan

552: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
553: ,hoi_challan.org_information5 Bank
554: ,hoi_challan.org_information3 Voucher_Num
555: ,hoi_challan.org_information11 DD_Cheque_Num
556: FROM hr_organization_information hoi_challan
557: WHERE hoi_challan.organization_id = p_gre_id
558: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
559: AND hoi_challan.org_information12 = 'Y'
560: AND hoi_challan.org_information5 is null

Line 571: FROM hr_organization_information hoi_bank

567: CURSOR csr_bank_pymt_16aa IS
568: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
569: ,hr_general.decode_lookup('IN_BANK',hoi_bank.org_information1)||','||hr_general.decode_lookup('IN_BANK_BRANCH',hoi_bank.org_information2) Bank
570: ,hoi_challan.org_information3 Voucher_Num
571: FROM hr_organization_information hoi_bank
572: ,hr_organization_information hoi_challan
573: WHERE hoi_bank.organization_id = p_gre_id
574: AND hoi_challan.organization_id = hoi_bank.organization_id
575: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'

Line 572: ,hr_organization_information hoi_challan

568: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
569: ,hr_general.decode_lookup('IN_BANK',hoi_bank.org_information1)||','||hr_general.decode_lookup('IN_BANK_BRANCH',hoi_bank.org_information2) Bank
570: ,hoi_challan.org_information3 Voucher_Num
571: FROM hr_organization_information hoi_bank
572: ,hr_organization_information hoi_challan
573: WHERE hoi_bank.organization_id = p_gre_id
574: AND hoi_challan.organization_id = hoi_bank.organization_id
575: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
576: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'

Line 585: FROM hr_organization_information hoi_challan

581: UNION ALL
582: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
583: ,hoi_challan.org_information5 Bank
584: ,hoi_challan.org_information3 Voucher_Num
585: FROM hr_organization_information hoi_challan
586: WHERE hoi_challan.organization_id = p_gre_id
587: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
588: AND hoi_challan.org_information12 = 'Y'
589: AND hoi_challan.org_information5 is null

Line 597: FROM hr_organization_information

593:
594: CURSOR csr_form24q_receipt IS
595: SELECT org_information2 quarter,DECODE(org_information6,'O',' Regular','C',' Correction') Nature,
596: org_information4 receipt
597: FROM hr_organization_information
598: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
599: AND org_information1 = g_assessment_year
600: AND organization_id = p_gre_id
601: ORDER BY quarter;

Line 2006: , hr_organization_information hoi

2002: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2003: IS
2004: SELECT hou.organization_id orgid
2005: FROM hr_all_organization_units hou
2006: , hr_organization_information hoi
2007: WHERE hou.organization_id = hoi.organization_id
2008: AND hoi.org_information_context = 'CLASS'
2009: AND hoi.org_information1 = 'HR_LEGAL'
2010: AND hoi.org_information2 = 'Y'