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.JAI_AP_TDS_ETDS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 596: FROM hr_all_organization_units

592:
593: -- to get TAN of an organization
594: CURSOR c_tan_number(p_organization_id IN NUMBER) IS
595: SELECT attribute1
596: FROM hr_all_organization_units
597: WHERE organization_id = p_organization_id;
598:
599: \*added by csahoo for bug # 6158875, START*\
600: \*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table *\

Line 1847: FROM hr_all_organization_units

1843:
1844: -- to get TAN of an organization
1845: CURSOR c_tan_number(p_organization_id IN NUMBER) IS
1846: SELECT attribute1
1847: FROM hr_all_organization_units
1848: WHERE organization_id = p_organization_id;
1849:
1850: /*added by csahoo for bug # 6158875, START*/
1851: /*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table */

Line 5067: FROM hr_all_organization_units

5063:
5064: -- gives Location_id linked to Organization/*ETDS FVU3.1 Bug 11896260 -Modified the below query*/
5065: CURSOR c_location_linked_to_org(p_organization_id IN NUMBER,p_deductor_addr_org_id IN NUMBER) IS
5066: SELECT location_id
5067: FROM hr_all_organization_units
5068: WHERE organization_id = nvl(p_organization_id,p_deductor_addr_org_id);
5069:
5070: -- to get address details of location linked to given organization
5071: CURSOR c_address_details(p_location_id IN NUMBER) IS