DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_PAYING_RELATIONSHIPS_V

Line 1149: FROM ar_paying_relationships_v rel,

1145: SELECT TO_NUMBER(p_bill_to_customer_id)
1146: FROM dual
1147: UNION
1148: SELECT acc.cust_account_id
1149: FROM ar_paying_relationships_v rel,
1150: hz_cust_accounts acc
1151: WHERE rel.party_id = acc.party_id
1152: AND rel.related_cust_account_id = p_bill_to_customer_id
1153: AND p_ct_prev_trx_date BETWEEN effective_start_date