APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_ACCT_SITES

Line 37: customer_id hz_cust_acct_sites.cust_account_id%TYPE,

33:
34: /* modified for tca uptake */
35: TYPE Site_Use_Cache_Rec_Type IS RECORD
36: (id hz_cust_site_uses.site_use_id%TYPE,
37: customer_id hz_cust_acct_sites.cust_account_id%TYPE,
38: site_use_code hz_cust_site_uses.site_use_code%TYPE,
39: location hz_cust_site_uses.location%TYPE,
40: primary_flag VARCHAR2(1)
41: );

Line 710: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

706:
707:
708: /* modified for tca uptake */
709: PROCEDURE Add_Site_Use_To_Cache(
710: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
711: p_location IN hz_cust_site_uses.location%TYPE,
712: p_site_use_code IN hz_cust_site_uses.site_use_code%TYPE,
713: p_id IN hz_cust_site_uses.site_use_id%TYPE,
714: p_index IN BINARY_INTEGER

Line 803: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

799: END Find_Site_Use_In_Cache;
800:
801: /* modified for tca uptake */
802: FUNCTION Get_Site_Use_Id(
803: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
804: p_location IN hz_cust_site_uses.location%TYPE,
805: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
806: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL)
807: RETURN hz_cust_site_uses.site_use_id%type IS

Line 837: hz_cust_acct_sites acct_site

833: /* modified for tca uptake */
834: SELECT site_use.site_use_id
835: INTO l_selected_id
836: FROM hz_cust_site_uses site_use,
837: hz_cust_acct_sites acct_site
838: WHERE acct_site.cust_account_id = p_customer_id
839: AND acct_site.status = 'A'
840: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
841: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 864: hz_cust_acct_sites acct_site

860: /* modified for tca uptake */
861: SELECT site_use.site_use_id
862: INTO l_selected_id
863: FROM hz_cust_site_uses site_use,
864: hz_cust_acct_sites acct_site
865: WHERE acct_site.cust_account_id = p_customer_id
866: AND acct_site.status = 'A'
867: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
868: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 3634: hz_cust_acct_sites acct_site

3630: /* modified for tca uptake */
3631: CURSOR get_site_use_id IS
3632: SELECT site_use_id
3633: FROM hz_cust_site_uses site_use,
3634: hz_cust_acct_sites acct_site
3635: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
3636: AND acct_site.cust_account_id = p_customer_id
3637: AND site_use.location = l_location
3638: AND site_use.site_use_code IN ('BILL_TO','DRAWEE');

Line 8308: FROM hz_cust_acct_sites_all cas,

8304: null)*/
8305: , loc.address1
8306: INTO p_party_site_id
8307: ,x_party_address
8308: FROM hz_cust_acct_sites_all cas,
8309: hz_cust_site_uses_all csu,
8310: hz_party_sites ps,
8311: hz_locations loc
8312: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id