APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_FINANCE_CHARGE_GRP_DTLS

Line 1361: FROM fv_finance_charge_grp_dtls fcgd,

1357:
1358: IF (p_retcode = g_SUCCESS) THEN
1359: FOR dm_rec IN (SELECT fcgd.base_charge_id,
1360: fcgd.assessed_charge_id
1361: FROM fv_finance_charge_grp_dtls fcgd,
1362: fv_finance_charge_grp_hdrs fcgh
1363: WHERE fcgh.finance_charge_group_hdr_id = p_finance_charge_group_hdr_id
1364: AND fcgd.finance_charge_group_hdr_id = fcgh.finance_charge_group_hdr_id
1365: AND fcgd.base_charge_id = p_charge_id

Line 1711: fv_finance_charge_grp_dtls fcgd,

1707: --bug 9716140
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

Line 1732: fv_finance_charge_grp_dtls fcgd,

1728: AND rsua.site_use_id = rct.bill_to_site_use_id
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

Line 2098: fv_finance_charge_grp_dtls fcgd

2094: AND fcc.charge_id = charge_id
2095: AND set_of_books_id = c_ledger_id)
2096: AND NOT EXISTS (SELECT 'x'
2097: FROM fv_finance_chrg_cust_classes fccc,
2098: fv_finance_charge_grp_dtls fcgd
2099: WHERE fccc.customer_class = hzca.customer_class_code
2100: AND fccc.enabled_flag = 'Y'
2101: AND fccc.finance_charge_group_hdr_id = fcgd.finance_charge_group_hdr_id
2102: AND SYSDATE between NVL(fcgd.start_date, g_lo_date) and NVL(fcgd.end_date, g_hi_date)

Line 2185: fv_finance_charge_grp_dtls fcgd

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
2188: AND fcf.customer_class_code = fcfc.customer_class
2189: AND fcf.customer_class_code = hzca.customer_class_code

Line 2208: fv_finance_charge_grp_dtls fcgd

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
2211: AND fcf.customer_class_code = fcfc.customer_class
2212: AND fcf.customer_class_code = hzca.customer_class_code

Line 2248: fv_finance_charge_grp_dtls fcgd,

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
2250: WHERE fcc.enabled_flag = 'Y'
2251: AND fcc.set_of_books_id = g_set_of_books_id
2252: AND hzca.status = 'A'

Line 2314: fv_finance_charge_grp_dtls fcgd,

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
2316: WHERE fcc.enabled_flag = 'Y'
2317: AND fcc.set_of_books_id = g_set_of_books_id
2318: AND hzca.status = 'A'

Line 2468: fv_finance_charge_grp_dtls fcgd,

2464: FROM ra_customer_trx ract,
2465: fv_cust_finance_chrgs fcfc,
2466: fv_finance_charge_controls fcc,
2467: ra_cust_trx_types rctt,
2468: fv_finance_charge_grp_dtls fcgd,
2469: fv_finance_charge_grp_hdrs fcgh
2470: WHERE ract.bill_to_customer_id = fcfc.customer_id
2471: AND fcfc.set_of_books_id = g_set_of_books_id
2472: AND ract.cust_trx_type_id = rctt.cust_trx_type_id