DBA Data[Home] [Help]

APPS.FV_GTAS_TRX_REGISTER dependencies on HZ_CUST_SITE_USES_ALL

Line 2603: hz_cust_site_uses_all hcsu,

2599: INTO l_reference_4,
2600: l_reference_7
2601: FROM ar_receivable_applications_all ara,
2602: ar_cash_receipts_all acr,
2603: hz_cust_site_uses_all hcsu,
2604: hz_cust_acct_sites_all hcas,
2605: hz_cust_accounts hca
2606: WHERE ara.receivable_application_id = l_ar_source_id
2607: AND ara.cash_receipt_id = acr.cash_receipt_id

Line 2633: hz_cust_site_uses_all hcsu,

2629: INTO l_reference_4,
2630: l_reference_7
2631: FROM ar_cash_receipt_history_all ara,
2632: ar_cash_receipts_all acr,
2633: hz_cust_site_uses_all hcsu,
2634: hz_cust_acct_sites_all hcas,
2635: hz_cust_accounts hca
2636: WHERE ara.cash_receipt_history_id = l_ar_source_id
2637: AND ara.cash_receipt_id = acr.cash_receipt_id

Line 2663: hz_cust_site_uses_all hcsu,

2659: INTO l_reference_4,
2660: l_reference_7
2661: FROM ar_adjustments_all ara,
2662: ar_cash_receipts_all acr,
2663: hz_cust_site_uses_all hcsu,
2664: hz_cust_acct_sites_all hcas,
2665: hz_cust_accounts hca
2666: WHERE ara.adjustment_id = l_ar_source_id
2667: AND ara.associated_cash_receipt_id = acr.cash_receipt_id

Line 2690: hz_cust_site_uses_all hcsu,

2686: INTO l_reference_4,
2687: l_reference_7
2688: FROM ar_misc_cash_distributions_all ara,
2689: ar_cash_receipts_all acr,
2690: hz_cust_site_uses_all hcsu,
2691: hz_cust_acct_sites_all hcas,
2692: hz_cust_accounts hca
2693: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2694: AND ara.cash_receipt_id = acr.cash_receipt_id