APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on FV_FINANCE_CHARGE_GRP_HDRS

Line 1362: fv_finance_charge_grp_hdrs fcgh

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
1366: AND fcgd.start_date <= sysdate

Line 2184: fv_finance_charge_grp_hdrs fcgh,

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

Line 2207: fv_finance_charge_grp_hdrs fcgh,

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

Line 2249: fv_finance_charge_grp_hdrs fcgh

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'
2253: AND fccc.customer_class = hzca.customer_class_code

Line 2315: fv_finance_charge_grp_hdrs fcgh

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'
2319: AND fccc.customer_class = hzca.customer_class_code

Line 2469: fv_finance_charge_grp_hdrs fcgh

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
2473: AND ract.complete_flag = 'Y'