APPS.ASN_PARTY_MERGE_PVT dependencies on AS_AP_ACCOUNT_PLANS

Line 38: FROM as_ap_account_plans

34: l_account_plan_id NUMBER(10);
35:
36: CURSOR c_merge_acctplan IS
37: SELECT 1
38: FROM as_ap_account_plans
39: WHERE cust_party_id = p_from_fk_id
40: FOR UPDATE NOWAIT;
41:
42: CURSOR c_account_plan IS

Line 44: FROM as_ap_account_plans

40: FOR UPDATE NOWAIT;
41:
42: CURSOR c_account_plan IS
43: SELECT account_plan_id
44: FROM as_ap_account_plans
45: WHERE cust_party_id = p_to_fk_id;
46:
47:
48: BEGIN

Line 70: UPDATE as_ap_account_plans

66: FETCH c_account_plan into l_account_plan_id;
67: IF c_account_plan%NOTFOUND THEN
68: OPEN c_merge_acctplan;
69: CLOSE c_merge_acctplan;
70: UPDATE as_ap_account_plans
71: SET cust_party_id = p_to_fk_id,
72: last_update_date = hz_utility_pub.last_update_date,
73: last_updated_by = hz_utility_pub.user_id,
74: last_update_login = hz_utility_pub.last_update_login