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 707: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

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

Line 800: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

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

Line 834: hz_cust_acct_sites acct_site

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

Line 861: hz_cust_acct_sites acct_site

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

Line 3449: hz_cust_acct_sites acct_site

3445: /* modified for tca uptake */
3446: CURSOR get_site_use_id IS
3447: SELECT site_use_id
3448: FROM hz_cust_site_uses site_use,
3449: hz_cust_acct_sites acct_site
3450: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
3451: AND acct_site.cust_account_id = p_customer_id
3452: AND site_use.location = l_location
3453: AND site_use.site_use_code IN ('BILL_TO','DRAWEE');

Line 8009: FROM hz_cust_acct_sites_all cas,

8005: null)*/
8006: , loc.address1
8007: INTO p_party_site_id
8008: ,x_party_address
8009: FROM hz_cust_acct_sites_all cas,
8010: hz_cust_site_uses_all csu,
8011: hz_party_sites ps,
8012: hz_locations loc
8013: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id