DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_PAYING_RELATIONSHIPS_V

Line 3682: FROM ar_paying_relationships_v rel,

3678: SELECT p_cr_customer_id
3679: FROM dual
3680: UNION
3681: SELECT rel.related_cust_account_id
3682: FROM ar_paying_relationships_v rel,
3683: hz_cust_accounts acc
3684: WHERE rel.party_id = acc.party_id
3685: AND acc.cust_account_id = p_cr_customer_id
3686: AND p_cr_date BETWEEN effective_start_date

Line 3857: FROM ar_paying_relationships_v rel,

3853: SELECT p_cr_customer_id
3854: FROM dual
3855: UNION
3856: SELECT rel.related_cust_account_id
3857: FROM ar_paying_relationships_v rel,
3858: hz_cust_accounts acc
3859: WHERE rel.party_id = acc.party_id
3860: AND acc.cust_account_id = p_cr_customer_id
3861: AND p_cr_date BETWEEN effective_start_date