DBA Data[Home] [Help]

APPS.ARP_BF_BILL dependencies on HZ_PARTIES

Line 980: c_site_from := c_site_from || ', hz_parties party, hz_cust_accounts acct ';

976: ' AND CI2.status = ''DRAFT'') ';
977:
978: -- add on tables/conditions depending on parameters passed in
979: IF l_cust_name_low is not null THEN
980: c_site_from := c_site_from || ', hz_parties party, hz_cust_accounts acct ';
981:
982: c_site_where := c_site_where ||
983: 'AND party.party_name between :cust_name_low and :cust_name_high ' ||
984: 'AND party.party_id = acct.party_id ' ||

Line 1205: from hz_parties p, hz_cust_accounts c

1201:
1202: /* get party_id */
1203: select p.party_id
1204: into l_party_id
1205: from hz_parties p, hz_cust_accounts c
1206: where c.cust_account_id = L_sites.customer_id
1207: and c.party_id = p.party_id;
1208:
1209: