APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on HZ_CUST_ACCT_RELATE

Line 115: FROM hz_cust_acct_relate

111: From pa_implementations;
112:
113: CURSOR C2 IS
114: SELECT related_cust_account_id
115: FROM hz_cust_acct_relate
116: WHERE cust_account_id = l_customer_id
117: AND bill_to_flag = 'Y'
118: AND status = 'A'
119: AND related_cust_account_id = l_bill_to_customer_id;

Line 123: FROM hz_cust_acct_relate

119: AND related_cust_account_id = l_bill_to_customer_id;
120:
121: CURSOR C3 IS
122: SELECT related_cust_account_id
123: FROM hz_cust_acct_relate
124: WHERE cust_account_id = l_customer_id
125: AND ship_to_flag = 'Y'
126: AND status = 'A'
127: AND related_cust_account_id = l_ship_to_customer_id;

Line 820: FROM hz_cust_acct_relate

816: From pa_implementations;
817:
818: CURSOR C3 IS
819: SELECT related_cust_account_id
820: FROM hz_cust_acct_relate
821: WHERE cust_account_id = p_customer_id
822: AND bill_to_flag = 'Y'
823: AND status = 'A'
824: AND related_cust_account_id = l_bill_to_customer_id;

Line 828: FROM hz_cust_acct_relate

824: AND related_cust_account_id = l_bill_to_customer_id;
825:
826: CURSOR C4 IS
827: SELECT related_cust_account_id
828: FROM hz_cust_acct_relate
829: WHERE cust_account_id = p_customer_id
830: AND ship_to_flag = 'Y'
831: AND status = 'A'
832: AND related_cust_account_id = l_ship_to_customer_id;