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 675: FROM hr_organization_information hoi_bank

671: ((SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
672: ,hoi_bank.org_information4 Bank
673: ,hoi_challan.org_information3 Voucher_Num
674: ,hoi_challan.org_information11 DD_Cheque_Num
675: FROM hr_organization_information hoi_bank
676: ,hr_organization_information hoi_challan
677: WHERE hoi_bank.organization_id = p_gre_id
678: AND hoi_challan.organization_id = hoi_bank.organization_id
679: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'

Line 676: ,hr_organization_information hoi_challan

672: ,hoi_bank.org_information4 Bank
673: ,hoi_challan.org_information3 Voucher_Num
674: ,hoi_challan.org_information11 DD_Cheque_Num
675: FROM hr_organization_information hoi_bank
676: ,hr_organization_information hoi_challan
677: WHERE hoi_bank.organization_id = p_gre_id
678: AND hoi_challan.organization_id = hoi_bank.organization_id
679: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
680: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'

Line 690: FROM hr_organization_information hoi_challan

686: (SELECT fnd_date.canonical_to_date(hoi_challan.org_information2) Payment_date
687: ,hoi_challan.org_information5 Bank
688: ,hoi_challan.org_information3 Voucher_Num
689: ,hoi_challan.org_information11 DD_Cheque_Num
690: FROM hr_organization_information hoi_challan
691: WHERE hoi_challan.organization_id = p_gre_id
692: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
693: AND hoi_challan.org_information12 = 'Y'
694: AND hoi_challan.org_information5 is null

Line 704: FROM hr_organization_information

700: SELECT org_information2 quarter,DECODE(org_information6,'O',' Regular','C',' Correction') Nature,
701: org_information4 receipt,
702: organization_id orgID,
703: to_number(org_information3) ActionID
704: FROM hr_organization_information
705: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
706: AND org_information1 = g_assessment_year
707: AND organization_id = p_gre_id
708: AND org_information5 = 'A'

Line 2309: , hr_organization_information hoi

2305: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2306: IS
2307: SELECT hou.organization_id orgid
2308: FROM hr_all_organization_units hou
2309: , hr_organization_information hoi
2310: WHERE hou.organization_id = hoi.organization_id
2311: AND hoi.org_information_context = 'CLASS'
2312: AND hoi.org_information1 = 'HR_LEGAL'
2313: AND hoi.org_information2 = 'Y'

Line 2566: , hr_organization_information hoi

2562: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2563: IS
2564: SELECT hou.organization_id orgid
2565: FROM hr_all_organization_units hou
2566: , hr_organization_information hoi
2567: WHERE hou.organization_id = hoi.organization_id
2568: AND hoi.org_information_context = 'CLASS'
2569: AND hoi.org_information1 = 'HR_LEGAL'
2570: AND hoi.org_information2 = 'Y'