APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on HZ_CUST_ACCOUNTS

Line 1712: hz_cust_accounts hzca

1708: AND (rct.related_customer_trx_id IS NULL OR
1709: EXISTS(SELECT 'x'
1710: FROM fv_finance_chrg_cust_classes fccc,
1711: fv_finance_charge_grp_dtls fcgd,
1712: hz_cust_accounts hzca
1713: WHERE fccc.finance_charge_group_hdr_id = fcgd.finance_charge_group_hdr_id
1714: AND fccc.enabled_flag = 'Y'
1715: AND fcgd.assessed_charge_id = fcc.charge_id
1716: AND fcgd.base_charge_id <> 0

Line 1733: hz_cust_accounts hzca

1729: AND fai.invoice_id = fifc.customer_trx_id
1730: AND EXISTS ( SELECT 'x'
1731: FROM fv_finance_chrg_cust_classes fccc,
1732: fv_finance_charge_grp_dtls fcgd,
1733: hz_cust_accounts hzca
1734: WHERE fccc.customer_class = hzca.customer_class_code
1735: AND fccc.enabled_flag = 'Y'
1736: AND fccc.finance_charge_group_hdr_id = fcgd.finance_charge_group_hdr_id
1737: AND fcgd.assessed_charge_id = fcc.charge_id

Line 2086: FROM hz_cust_accounts hzca,

2082:
2083: CURSOR c1 (c_ledger_id NUMBER) IS
2084: SELECT DISTINCT hzca.cust_Account_id customer_id,
2085: hzca.customer_class_code cust_class_code
2086: FROM hz_cust_accounts hzca,
2087: fv_finance_charge_controls fcc
2088: WHERE fcc.enabled_flag = 'Y'
2089: AND fcc.set_of_books_id = c_ledger_id
2090: AND hzca.status = 'A'

Line 2156: hz_cust_accounts hzca

2152: SET waive_flag = 'Y'
2153: WHERE customer_id = customer.customer_id
2154: AND charge_id NOT IN (SELECT charge_id
2155: FROM fv_finance_chrg_cust_classes,
2156: hz_cust_accounts hzca
2157: WHERE hzca.cust_account_id = customer.customer_id
2158: AND customer_class = hzca.customer_class_code
2159: AND enabled_flag = 'Y'
2160: AND set_of_books_id = g_set_of_books_id);*/

Line 2183: hz_cust_accounts hzca,

2179: WHERE customer_id = customer.customer_id
2180: AND charge_id NOT IN (SELECT fcf.charge_id
2181: FROM fv_cust_finance_chrgs fcf,
2182: fv_finance_chrg_cust_classes fcfc,
2183: hz_cust_accounts hzca,
2184: fv_finance_charge_grp_hdrs fcgh,
2185: fv_finance_charge_grp_dtls fcgd
2186: WHERE hzca.cust_account_id = customer.customer_id
2187: AND fcf.customer_id = hzca.cust_account_id

Line 2206: hz_cust_accounts hzca,

2202: WHERE customer_id = customer.customer_id
2203: AND charge_id IN (SELECT fcf.charge_id
2204: FROM fv_cust_finance_chrgs fcf,
2205: fv_finance_chrg_cust_classes fcfc,
2206: hz_cust_accounts hzca,
2207: fv_finance_charge_grp_hdrs fcgh,
2208: fv_finance_charge_grp_dtls fcgd
2209: WHERE hzca.cust_account_id = customer.customer_id
2210: AND fcf.customer_id = hzca.cust_account_id

Line 2245: FROM hz_cust_accounts hzca,

2241: BEGIN
2242: DELETE FROM fv_cust_finance_chrgs WHERE
2243: customer_id IN
2244: (SELECT hzca.cust_account_id
2245: FROM hz_cust_accounts hzca,
2246: fv_finance_charge_controls fcc,
2247: fv_finance_chrg_cust_classes fccc,
2248: fv_finance_charge_grp_dtls fcgd,
2249: fv_finance_charge_grp_hdrs fcgh

Line 2311: FROM hz_cust_accounts hzca,

2307: fccc.customer_class,
2308: fcgh.finance_charge_group_hdr_id,
2309: fcgd.base_charge_id,
2310: g_request_id
2311: FROM hz_cust_accounts hzca,
2312: fv_finance_charge_controls fcc,
2313: fv_finance_chrg_cust_classes fccc,
2314: fv_finance_charge_grp_dtls fcgd,
2315: fv_finance_charge_grp_hdrs fcgh