APPS.AR_INVOICE_UTILS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 784: FROM hz_cust_account_roles acct_role,

780: FROM ar_trx_header_gt gt
781: WHERE gt.bill_to_contact_id IS NOT NULL
782: AND NOT EXISTS
783: (SELECT 'X'
784: FROM hz_cust_account_roles acct_role,
785: hz_parties party,
786: hz_relationships rel,
787: hz_org_contacts org_cont,
788: hz_parties rel_party

Line 839: FROM hz_cust_account_roles acct_role,

835: FROM ar_trx_header_gt gt
836: WHERE gt.ship_to_contact_id IS NOT NULL
837: AND NOT EXISTS
838: (SELECT 'X'
839: FROM hz_cust_account_roles acct_role,
840: hz_parties party,
841: hz_relationships rel,
842: hz_org_contacts org_cont,
843: hz_parties rel_party

Line 3285: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;

3281: SELECT distinct bill_to_customer_id,
3282: bill_to_address_id
3283: FROM ar_trx_header_gt
3284: WHERE bill_to_contact_id IS NULL;
3285: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;
3286: BEGIN
3287: IF pg_debug = 'Y'
3288: THEN
3289: debug ('AR_INVOICE_UTILS.populate_bill_to_contact_id(+)' );

Line 3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3296: LOOP
3297: BEGIN
3298: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3299: INTO l_contact_id
3300: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3301: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3302: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3303: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3304: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 3482: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;

3478: SELECT distinct ship_to_customer_id,
3479: ship_to_address_id
3480: FROM ar_trx_header_gt
3481: WHERE ship_to_contact_id IS NULL;
3482: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;
3483: BEGIN
3484: IF pg_debug = 'Y'
3485: THEN
3486: debug ('AR_INVOICE_UTILS.populate_ship_to_contact_id(+)' );

Line 3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,

3495: LOOP
3496: BEGIN
3497: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3498: INTO l_contact_id
3499: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3500: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3501: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3502: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3503: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID