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
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