APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_PARTIES

Line 1476: from hz_parties a, hz_cust_accounts b

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

Line 1490: Select party_name from HZ_PARTIES

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

Line 1493: select party_name from HZ_PARTIES

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

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

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