APPS.ARP_ARXCOBL_MLS_PACKAGE dependencies on HZ_PARTIES

Line 7: p_customer_name_from hz_parties.party_name%TYPE;

3:
4: function ARP_ARXCOBL_MLS_FUNCTION return varchar2 is
5:
6: -- variables used by build_where_clause
7: p_customer_name_from hz_parties.party_name%TYPE;
8: p_customer_name_to hz_parties.party_name%TYPE;
9: l_customer_id number := NULL;
10: p_where1 varchar2(8096);
11: p_where2 varchar2(8096);

Line 8: p_customer_name_to hz_parties.party_name%TYPE;

4: function ARP_ARXCOBL_MLS_FUNCTION return varchar2 is
5:
6: -- variables used by build_where_clause
7: p_customer_name_from hz_parties.party_name%TYPE;
8: p_customer_name_to hz_parties.party_name%TYPE;
9: l_customer_id number := NULL;
10: p_where1 varchar2(8096);
11: p_where2 varchar2(8096);
12: p_table1 varchar2(8096);

Line 32: hz_parties party

28: Cursor cusinfo(p_customer_name_from varchar2,
29: p_customer_name_to varchar2) is
30: SELECT cust_acct.cust_account_id customer_id
31: from hz_cust_accounts cust_acct,
32: hz_parties party
33: where cust_acct.party_id = party.party_id
34: and upper(party.party_name) between
35: nvl(upper(p_customer_name_from),'A')
36: and nvl(upper(p_customer_name_to),'Z');

Line 92: p_table1:=p_table1||',hz_parties party';

88:
89: /* bug1946875: add given customer parameters condition to where clause */
90: if (p_customer_name_to is not null
91: or p_customer_name_from is not null )then
92: p_table1:=p_table1||',hz_parties party';
93: p_where2:=p_where2||' and cust_acct.party_id = party.party_id' ;
94:
95: if p_customer_name_from is not null then
96: /* bug1994326: add equal sign */