DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 280: FROM hr_all_organization_units

276:
277: -- to get TAN of an organization
278: CURSOR c_tan_number(p_organization_id IN NUMBER) IS
279: SELECT attribute1
280: FROM hr_all_organization_units
281: WHERE organization_id = p_organization_id;
282:
283: -- p_invoice_id contains tds_invoice_id incase if tds amount is directly paid to TDS Authorities using a c
284: -- p_invoice_id contains PREPAYMENT invoice_id to TDS Auth., if TDS invoice is applied to PREPAYMENT invo

Line 3130: FROM hr_all_organization_units

3126:
3127: -- gives Location_id linked to Organization
3128: CURSOR c_location_linked_to_org(p_organization_id IN NUMBER) IS
3129: SELECT location_id
3130: FROM hr_all_organization_units
3131: WHERE organization_id = p_organization_id;
3132:
3133: -- to get address details of location linked to given organization
3134: CURSOR c_address_details(p_location_id IN NUMBER) IS