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_GENERAL

Line 248: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)

244: , hr_loc.address_line_2
245: , hr_loc.address_line_3
246: , hr_loc.loc_information14
247: , hr_loc.loc_information15
248: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
249: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
250: , hr_loc.postal_code
251: , hr_loc.loc_information16
252: FROM hr_locations hr_loc

Line 249: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)

245: , hr_loc.address_line_3
246: , hr_loc.loc_information14
247: , hr_loc.loc_information15
248: , hr_general.decode_lookup('IN_STATES',hr_loc.loc_information16)
249: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',hr_loc.country)
250: , hr_loc.postal_code
251: , hr_loc.loc_information16
252: FROM hr_locations hr_loc
253: WHERE location_id = p_location_id;

Line 365: , hr_general.decode_lookup('IN_STATES',pad.add_information15)

361: , pad.address_line2
362: , pad.address_line3
363: , pad.add_information13
364: , pad.add_information14
365: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
366: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
367: , pad.postal_code
368: FROM per_addresses pad
369: WHERE pad.address_id = p_address_id;

Line 366: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)

362: , pad.address_line3
363: , pad.add_information13
364: , pad.add_information14
365: , hr_general.decode_lookup('IN_STATES',pad.add_information15)
366: , hr_general.decode_lookup('PER_US_COUNTRY_CODE',pad.country)
367: , pad.postal_code
368: FROM per_addresses pad
369: WHERE pad.address_id = p_address_id;
370:

Line 569: ,hr_general.decode_lookup('IN_BANK',hoi_bank.org_information1)||','||hr_general.decode_lookup('IN_BANK_BRANCH',hoi_bank.org_information2) Bank

565: --Cursor to get challan details for Form16 AA
566:
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