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

Line 251: FROM hr_organization_information ch_b

247: , TO_CHAR(fnd_date.canonical_to_date(it_ch.org_information2),'DDMMYYYY')
248: , 'BANK_BRANCH_CODE=P'
249: , hr_general.decode_lookup('IN_BANK_BRANCH_CODES',ch_b.org_information4)
250: , fnd_date.canonical_to_date(it_ch.org_information2)
251: FROM hr_organization_information ch_b
252: , hr_organization_information it_ch
253: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
254: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
255: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

Line 252: , hr_organization_information it_ch

248: , 'BANK_BRANCH_CODE=P'
249: , hr_general.decode_lookup('IN_BANK_BRANCH_CODES',ch_b.org_information4)
250: , fnd_date.canonical_to_date(it_ch.org_information2)
251: FROM hr_organization_information ch_b
252: , hr_organization_information it_ch
253: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
254: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
255: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
256: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))

Line 284: FROM hr_organization_information ch_b

280: , SYSDATE
281: FROM DUAL
282: WHERE NOT EXISTS (
283: SELECT 'EXISTS'
284: FROM hr_organization_information ch_b
285: ,hr_organization_information it_ch
286: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
287: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
288: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')

Line 285: ,hr_organization_information it_ch

281: FROM DUAL
282: WHERE NOT EXISTS (
283: SELECT 'EXISTS'
284: FROM hr_organization_information ch_b
285: ,hr_organization_information it_ch
286: WHERE it_ch.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
287: AND ch_b.org_information_context = 'PER_IN_CHALLAN_BANK'
288: AND it_ch.organization_id = pay_magtape_generic.get_parameter_value('GRE_ORGANIZATION_PARAM')
289: AND it_ch.org_information1 = TO_CHAR((TO_NUMBER(SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4)) - 1)||'-'||SUBSTR(pay_magtape_generic.get_parameter_value('ASSESSMENT_YEAR_PARAM'),1,4))