APPS.CSD_RETURNS_UTIL dependencies on HZ_PARTIES

Line 1419: FROM hz_parties

1415: l_service_request_rec.ship_to_site_use_id := p_ship_to_addr_use_id;
1416: -- get the party type.
1417: SELECT party_type
1418: INTO l_party_type
1419: FROM hz_parties
1420: WHERE party_id = p_party_id;
1421: l_service_request_rec.caller_type := l_party_type;
1422: l_service_request_rec.customer_number := null;
1423: l_service_request_rec.customer_product_id := null;

Line 1443: FROM hz_contact_points contacts,hz_parties parties

1439: IF l_party_type = 'PERSON'
1440: THEN
1441: SELECT contacts.contact_point_id,contacts.owner_table_id
1442: INTO l_contact_point_id,l_contact_party_id
1443: FROM hz_contact_points contacts,hz_parties parties
1444: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1445: AND contacts.email_address = p_email
1446: AND parties.party_id = p_party_id
1447: AND contacts.owner_table_id = parties.party_id

Line 1444: WHERE contacts.owner_table_name = 'HZ_PARTIES'

1440: THEN
1441: SELECT contacts.contact_point_id,contacts.owner_table_id
1442: INTO l_contact_point_id,l_contact_party_id
1443: FROM hz_contact_points contacts,hz_parties parties
1444: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1445: AND contacts.email_address = p_email
1446: AND parties.party_id = p_party_id
1447: AND contacts.owner_table_id = parties.party_id
1448: AND contacts.status = 'A'

Line 1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr

1449: AND ROWNUM < 2;
1450: ELSE
1451: SELECT contacts.contact_point_id,contacts.owner_table_id
1452: INTO l_contact_point_id,l_contact_party_id
1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1455: AND contacts.email_address = p_email
1456: AND usr.user_id = fnd_global.user_id
1457: AND parties.party_id = usr.customer_id

Line 1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'

1450: ELSE
1451: SELECT contacts.contact_point_id,contacts.owner_table_id
1452: INTO l_contact_point_id,l_contact_party_id
1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1455: AND contacts.email_address = p_email
1456: AND usr.user_id = fnd_global.user_id
1457: AND parties.party_id = usr.customer_id
1458: AND contacts.owner_table_id = parties.party_id

Line 1480: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1476: IF l_create_contact
1477: THEN
1478: -- need to call hz api to create the contact point.
1479: l_contact_point_rec.contact_point_type := 'EMAIL';
1480: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1481: l_contact_point_rec.owner_table_id := l_contact_party_id;
1482: l_contact_point_rec.created_by_module := 'CSDSR';
1483: l_contact_point_rec.application_id := 512;
1484:

Line 1511: FROM hz_parties party

1507: IF l_party_type = 'PERSON'
1508: THEN
1509: SELECT party.party_type,party.party_id
1510: INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
1511: FROM hz_parties party
1512: WHERE party.party_id = p_party_id;
1513: ELSE
1514: SELECT party.party_type,party.party_id
1515: INTO l_service_request_rec.contact_type,l_service_request_rec.party_id

Line 1516: FROM hz_parties party,fnd_user usr

1512: WHERE party.party_id = p_party_id;
1513: ELSE
1514: SELECT party.party_type,party.party_id
1515: INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
1516: FROM hz_parties party,fnd_user usr
1517: WHERE usr.user_id = fnd_global.user_id
1518: AND usr.customer_id = party.party_id;
1519: END IF;
1520: ELSE