APPS.FUN_NET_APAR_UTILS_GRP dependencies on FUN_NET_AP_INVS_ALL

Line 32: from FUN_NET_AP_INVS_ALL

28: BEGIN
29: if(p_invoice_id IS NOT NULL) then
30: BEGIN
31: select batch_id into l_batch_id
32: from FUN_NET_AP_INVS_ALL
33: where invoice_id=p_invoice_id;
34: EXCEPTION
35: WHEN NO_DATA_FOUND THEN
36: RETURN 'N';

Line 82: select batch_id into x_batch_id from FUN_NET_AP_INVS_ALL where invoice_id=p_invoice_id;

78: x_msg_data OUT NOCOPY VARCHAR2) AS
79: BEGIN
80: if(p_invoice_id IS NOT NULL) then
81: Begin
82: select batch_id into x_batch_id from FUN_NET_AP_INVS_ALL where invoice_id=p_invoice_id;
83: exception
84: when NO_DATA_FOUND then
85: x_return_status:='E'; /* In this case the batch is not netted*/
86: x_msg_data:='Invoice ID was not found in any of the Netting Batch';