APPS.ASO_TAX_INT dependencies on JTF_RS_SRP_VL

Line 779: -- from jtf_rs_srp_vl Commented code Yogeshwar (MOAC)

775: where currency_code = l_currency_code;
776:
777: cursor c_person(c_resource_id number) is
778: select person_id,sales_tax_geocode,sales_tax_inside_city_limits, salesrep_id
779: -- from jtf_rs_srp_vl Commented code Yogeshwar (MOAC)
780: from JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
781: where resource_id=c_resource_id ;
782: --Commented code start yogeshwar (MOAC)
783: -- and nvl(org_id,nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1,1), ' ',

Line 2327: FROM jtf_rs_srp_vl sales, per_all_assignments_f per

2323: WHERE trx.quote_header_id = l_qte_hdr_id;
2324:
2325: Cursor c_get_org_id ( l_source_id NUMBER) is
2326: SELECT per.organization_id
2327: FROM jtf_rs_srp_vl sales, per_all_assignments_f per
2328: WHERE sales.resource_id = l_source_id
2329: AND per.person_id = sales.person_id
2330: AND nvl(per.primary_flag,'Y') = 'Y'
2331: AND sysdate BETWEEN nvl(per.effective_start_date,sysdate) AND nvl(per.effective_end_date,sysdate);