APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTIES

Line 1473: from hz_parties a, hz_cust_accounts b

1469: lc_cust_acct_det c_cust_acct_det%rowtype;
1470:
1471: CURSOR c_customer_details(lc_cust_acct_id NUMBER) IS
1472: select a.party_id, a.party_name,a.party_type
1473: from hz_parties a, hz_cust_accounts b
1474: where b.party_id = a.party_id
1475: and b.cust_account_id = lc_cust_acct_id;
1476:
1477: lc_customer_details c_customer_details%rowtype;

Line 1487: Select party_name from HZ_PARTIES

1483:
1484: lc_contact_partyid c_contact_partyid%rowtype;
1485:
1486: CURSOR c_contact_partyname(lc_cntct_partyid NUMBER) IS
1487: Select party_name from HZ_PARTIES
1488: where party_type = 'PERSON' and party_id = lc_cntct_partyid
1489: union
1490: select party_name from HZ_PARTIES
1491: where party_id =

Line 1490: select party_name from HZ_PARTIES

1486: CURSOR c_contact_partyname(lc_cntct_partyid NUMBER) IS
1487: Select party_name from HZ_PARTIES
1488: where party_type = 'PERSON' and party_id = lc_cntct_partyid
1489: union
1490: select party_name from HZ_PARTIES
1491: where party_id =
1492: (select subject_id from HZ_RELATIONSHIPS
1493: where party_id = lc_cntct_partyid and
1494: subject_type = 'PERSON' and object_type = 'ORGANIZATION');

Line 1504: NVL(status, 'A') = 'A' and owner_table_name = 'HZ_PARTIES'

1500: IBE_UTIL.format_phone(phone_country_code,phone_area_code,phone_number,phone_extension)phone_number,
1501: email_address
1502: from hz_contact_points
1503: where contact_point_type in ('PHONE','EMAIL') and
1504: NVL(status, 'A') = 'A' and owner_table_name = 'HZ_PARTIES'
1505: and owner_table_id = lc_cntct_prtyId
1506: and primary_flag='Y';
1507:
1508: lc_contact_details c_contact_details%rowtype;