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

Line 30: FROM hr_organization_information

26: ,p_assess_year VARCHAR2
27: ,p_quarter VARCHAR2)
28: IS
29: SELECT TO_CHAR(COUNT(*) + 1)
30: FROM hr_organization_information
31: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
32: AND org_information1 = p_assess_year
33: AND org_information2 = p_quarter
34: AND org_information6 = 'C'

Line 178: FROM hr_organization_information

174: ,p_quarter IN VARCHAR2)
175: IS
176: SELECT org_information4
177: ,org_information3
178: FROM hr_organization_information
179: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
180: AND org_information1 = p_assess_year
181: AND org_information2 = p_quarter
182: AND org_information6 ='O'

Line 192: FROM hr_organization_information

188: ,p_quarter IN VARCHAR2)
189: IS
190: SELECT org_information4
191: ,org_information3
192: FROM hr_organization_information
193: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
194: AND org_information1 = p_assess_year
195: AND org_information2 = p_quarter
196: AND organization_id = p_gre_org_id