APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_CUSTOMERS_V

Line 36: FROM pa_customers_v

32:
33:
34: CURSOR c_ids IS
35: SELECT customer_id
36: FROM pa_customers_v
37: WHERE upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) and status = 'A'; -- Bug 8314123
38: BEGIN
39: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then
40: if (p_customer_name is not NULL) then

Line 43: FROM pa_customers_v

39: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then
40: if (p_customer_name is not NULL) then
41: SELECT customer_id
42: INTO x_customer_id
43: FROM pa_customers_v
44: WHERE upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) -- Bug 8314123
45: and status = 'A';
46: else
47: x_customer_id := NULL;

Line 54: FROM pa_customers_v

50: else
51: if p_check_id_flag = 'Y' then
52: SELECT customer_id
53: INTO x_customer_id
54: FROM pa_customers_v
55: WHERE customer_id = p_customer_id;
56:
57: ELSIF (p_check_id_flag='N') THEN
58: x_customer_id := p_customer_id;

Line 145: FROM pa_customers_v

141:
142:
143: CURSOR c_ids IS
144: SELECT customer_id
145: FROM pa_customers_v
146: WHERE upper(customer_number) = upper(p_customer_number) and status = 'A';
147:
148: BEGIN
149: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then

Line 153: FROM pa_customers_v

149: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then
150: if (p_customer_number is not NULL) then
151: SELECT customer_id
152: INTO x_customer_id
153: FROM pa_customers_v
154: WHERE upper(customer_number) = upper(p_customer_number)
155: and status = 'A';
156: else
157: x_customer_id := NULL;

Line 164: FROM pa_customers_v

160: else
161: if p_check_id_flag = 'Y' then
162: SELECT customer_id
163: INTO x_customer_id
164: FROM pa_customers_v
165: WHERE customer_id = p_customer_id;
166:
167: ELSIF (p_check_id_flag='N') THEN
168: x_customer_id := p_customer_id;

Line 1387: FROM pa_customers_v

1383:
1384: BEGIN
1385: SELECT customer_id
1386: INTO x_customer_id
1387: FROM pa_customers_v
1388: WHERE upper(customer_number) = upper(p_customer_number) and
1389: upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) -- Bug 8314123
1390: and status = 'A';
1391: