APPS.XNP_UTILS dependencies on XNP_SV_SOA

Line 129: FROM XNP_SV_SOA

125: WHERE subscription_tn BETWEEN
126: starting_number AND ending_number );
127: CURSOR get_tn is
128: SELECT subscription_tn
129: FROM XNP_SV_SOA
130: WHERE object_reference = p_porting_id ;
131:
132: BEGIN
133:

Line 236: FROM XNP_SV_SOA

232: );
233:
234: -- Get the donor sp id from the SOA table
235: SELECT DONOR_SP_ID INTO l_DONOR_SP_ID
236: FROM XNP_SV_SOA
237: WHERE OBJECT_REFERENCE = l_PORTING_ID;
238:
239: ELSE
240:

Line 474: FROM XNP_SV_SOA

470: );
471:
472: -- Get the donor sp id from the SOA table
473: SELECT RECIPIENT_SP_ID INTO l_RECIPIENT_SP_ID
474: FROM XNP_SV_SOA
475: WHERE OBJECT_REFERENCE = l_PORTING_ID;
476: ELSE
477:
478: XNP_CORE.GET_SP_ID