APPS.PA_CUSTOMER_INFO dependencies on HZ_CUST_ACCOUNT_ROLES

Line 994: hz_cust_account_roles acct_role,

990: */
991: SELECT 'Y'
992: INTO l_return_value
993: FROM
994: hz_cust_account_roles acct_role,
995: hz_role_responsibility hrrep
996: WHERE acct_role.cust_account_id = l_Customer_Id
997: and acct_role.cust_account_role_id = l_Contact_Id
998: and acct_role.cust_account_role_id = hrrep.cust_account_role_id

Line 1036: hz_cust_account_roles acct_role ,

1032: */
1033: SELECT 'Y'
1034: INTO l_return_value
1035: FROM
1036: hz_cust_account_roles acct_role ,
1037: hz_role_responsibility hrrep ,
1038: hz_cust_acct_sites_all acct_site
1039: WHERE acct_role.cust_account_id = l_Customer_Id
1040: and acct_role.cust_account_role_id = hrrep.cust_account_role_id