APPS.AP_BANKACCT_INACTIVE_WF_PKG dependencies on IBY_PAYEE_ASSIGNED_BANKACCT_V

Line 121: l_debug_info := 'Deriving Vendor_Site_Id, Org_Id from Iby_Payee_Assigned_Bankacct_v';

117: ||', P_party_Id: '||p_party_id
118: ||', P_instr_assgn_id: '||p_instr_assgn_id);
119: END IF;
120:
121: l_debug_info := 'Deriving Vendor_Site_Id, Org_Id from Iby_Payee_Assigned_Bankacct_v';
122: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
124: END IF;
125:

Line 137: FROM Iby_Payee_Assigned_Bankacct_V

133: l_party_site_id,
134: l_supplier_site_id,
135: l_org_id,
136: l_currency_code
137: FROM Iby_Payee_Assigned_Bankacct_V
138: WHERE instr_assignment_id = p_instr_assgn_id
139: AND ext_bank_account_id = p_bank_account_id
140: AND party_id = p_party_id;
141: EXCEPTION

Line 143: l_debug_info := 'Iby_Payee_Assigned_Bankacct_V has no row for Assignment Id';

139: AND ext_bank_account_id = p_bank_account_id
140: AND party_id = p_party_id;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: l_debug_info := 'Iby_Payee_Assigned_Bankacct_V has no row for Assignment Id';
144: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
146: END IF;
147: RETURN FALSE;