APPS.AHL_PRD_NONROUTINE_PVT dependencies on HZ_PARTIES

Line 682: from hz_parties

678: BEGIN
679: Select party_name
680: into
681: l_customer_name
682: from hz_parties
683: where party_id
684: = p_x_sr_task_rec.customer_id;
685:
686: IF (l_customer_name <> nvl(p_x_sr_task_rec.customer_name,l_customer_name) and

Line 718: from hz_parties

714: BEGIN
715: Select party_id
716: into
717: l_customer_id
718: from hz_parties
719: where party_name = p_x_sr_task_rec.customer_name;
720: p_x_sr_task_rec.customer_id := l_customer_id;
721:
722: EXCEPTION

Line 764: from hz_parties

760: BEGIN
761: Select party_name
762: into
763: l_contact_name
764: from hz_parties
765: where party_id
766: = p_x_sr_task_rec.contact_id;
767:
768:

Line 801: from hz_parties

797: BEGIN
798: Select party_id
799: into
800: l_contact_id
801: from hz_parties
802: where party_name = p_x_sr_task_rec.contact_name;
803:
804: p_x_sr_task_rec.contact_id := l_contact_id;
805:

Line 1017: from hz_parties

1013: BEGIN
1014: Select party_name
1015: into
1016: l_contact_name
1017: from hz_parties
1018: where party_id
1019: = p_x_sr_task_rec.contact_id;
1020:
1021: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and

Line 1054: from hz_parties

1050: BEGIN
1051: Select party_id
1052: into
1053: l_contact_id
1054: from hz_parties
1055: where party_name = p_x_sr_task_rec.contact_name;
1056:
1057: p_x_sr_task_rec.contact_id := l_contact_id;
1058:

Line 1298: FROM hz_parties

1294: WHERE user_id = fnd_global.user_id;
1295:
1296: CURSOR default_customer_type IS
1297: SELECT party_type
1298: FROM hz_parties
1299: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1300:
1301: -- Changes made by by VSUNDARA For SR Integration
1302: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS

Line 1309: FROM hz_parties

1305: WHERE instance_id = p_item_instance_number;
1306:
1307: CURSOR owner_customer_type(p_cust_id IN NUMBER) IS
1308: SELECT party_type
1309: FROM hz_parties
1310: WHERE party_id = p_cust_id;
1311:
1312:
1313: -- End Changes

Line 1532: from hz_parties

1528: --Just to Check
1529: Select party_name
1530: into
1531: p_x_sr_task_rec.customer_name
1532: from hz_parties
1533: where party_id = p_x_sr_task_rec.customer_id;
1534: IF ( default_party_id%NOTFOUND) THEN
1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);