DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_PAYING_RELATIONSHIPS_V

Line 1152: FROM ar_paying_relationships_v rel,

1148: FROM dual
1149: WHERE cust_acct.cust_account_id =TO_NUMBER(p_bill_to_customer_id)
1150: UNION ALL
1151: SELECT 'X'
1152: FROM ar_paying_relationships_v rel,
1153: hz_cust_accounts acc
1154: WHERE rel.party_id = acc.party_id
1155: AND rel.related_cust_account_id = p_bill_to_customer_id
1156: AND p_ct_prev_trx_date BETWEEN effective_start_date