APPS.PA_CUSTOMER_INFO dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1003: hz_cust_account_roles acct_role,

999: */
1000: SELECT 'Y'
1001: INTO l_return_value
1002: FROM
1003: hz_cust_account_roles acct_role,
1004: hz_role_responsibility hrrep
1005: WHERE acct_role.cust_account_id = l_Customer_Id
1006: and acct_role.cust_account_role_id = l_Contact_Id
1007: and acct_role.cust_account_role_id = hrrep.cust_account_role_id

Line 1045: hz_cust_account_roles acct_role ,

1041: */
1042: SELECT 'Y'
1043: INTO l_return_value
1044: FROM
1045: hz_cust_account_roles acct_role ,
1046: hz_role_responsibility hrrep ,
1047: hz_cust_acct_sites_all acct_site
1048: WHERE acct_role.cust_account_id = l_Customer_Id
1049: and acct_role.cust_account_role_id = hrrep.cust_account_role_id