APPS.AR_INVOICE_UTILS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 791: FROM hz_cust_account_roles acct_role,

787: FROM ar_trx_header_gt gt
788: WHERE gt.bill_to_contact_id IS NOT NULL
789: AND NOT EXISTS
790: (SELECT 'X'
791: FROM hz_cust_account_roles acct_role,
792: hz_parties party,
793: hz_relationships rel,
794: hz_org_contacts org_cont,
795: hz_parties rel_party

Line 846: FROM hz_cust_account_roles acct_role,

842: FROM ar_trx_header_gt gt
843: WHERE gt.ship_to_contact_id IS NOT NULL
844: AND NOT EXISTS
845: (SELECT 'X'
846: FROM hz_cust_account_roles acct_role,
847: hz_parties party,
848: hz_relationships rel,
849: hz_org_contacts org_cont,
850: hz_parties rel_party

Line 3380: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;

3376: SELECT distinct bill_to_customer_id,
3377: bill_to_address_id
3378: FROM ar_trx_header_gt
3379: WHERE bill_to_contact_id IS NULL;
3380: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;
3381: BEGIN
3382: IF pg_debug = 'Y'
3383: THEN
3384: debug ('AR_INVOICE_UTILS.populate_bill_to_contact_id(+)' );

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

3391: LOOP
3392: BEGIN
3393: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3394: INTO l_contact_id
3395: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3396: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3397: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3398: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3399: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID

Line 3577: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;

3573: SELECT distinct ship_to_customer_id,
3574: ship_to_address_id
3575: FROM ar_trx_header_gt
3576: WHERE ship_to_contact_id IS NULL;
3577: l_contact_id HZ_CUST_ACCOUNT_ROLES.CUST_ACCOUNT_ROLE_ID%type;
3578: BEGIN
3579: IF pg_debug = 'Y'
3580: THEN
3581: debug ('AR_INVOICE_UTILS.populate_ship_to_contact_id(+)' );

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

3590: LOOP
3591: BEGIN
3592: SELECT distinct ACCT_ROLE.CUST_ACCOUNT_ROLE_ID -- CONTACT_ID
3593: INTO l_contact_id
3594: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,HZ_PARTIES PARTY,HZ_RELATIONSHIPS REL,
3595: HZ_ORG_CONTACTS ORG_CONT,HZ_PARTIES REL_PARTY
3596: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3597: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3598: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID