APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on FV_INVOICE_STATUSES_ALL

Line 260: --FV_INVOICE_STATUSES_ALL fvis

256: hz_parties hzp1,
257: FV_RECEIVABLE_TYPES_ALL frt,
258: FV_REC_CUST_TRX_TYPES_ALL fctt,
259: GL_CODE_COMBINATIONS glc
260: --FV_INVOICE_STATUSES_ALL fvis
261: WHERE rct.customer_trx_id = rctlgd.customer_trx_id
262: AND rct.trx_date <= vg_end_date
263: AND rctlgd.account_class = 'REC'
264: AND rctlgd.set_of_books_id = vp_sob_id

Line 301: -- FV_INVOICE_STATUSES_ALL fvis

297: AR_PAYMENT_SCHEDULES_ALL aps2,
298: --RA_CUSTOMERS rc2 Bug#4476059 Quick Change
299: hz_cust_accounts hzca2,
300: hz_parties hzp2
301: -- FV_INVOICE_STATUSES_ALL fvis
302: where aps2.class in ('DM','CM')
303: and hzca2.cust_account_id = rct2.bill_to_customer_id
304: and hzca2.party_id = hzp2.party_id
305: and rct2.customer_trx_id = aps2.customer_trx_id

Line 346: FROM ra_customer_trx_all rct , fv_invoice_statuses_all fvis

342: ---AND NVL(fvis.end_date, vg_end_date) ;
343:
344: CURSOR CUR_INV_STATUS( p_customer_trx_id NUMBER ) IS
345: SELECT status
346: FROM ra_customer_trx_all rct , fv_invoice_statuses_all fvis
347: WHERE rct.customer_trx_id = P_customer_trx_id
348: AND fvis.customer_trx_id = rct.customer_trx_id
349: AND vg_end_date BETWEEN NVL(fvis.start_date,vg_end_date)
350: AND NVL(fvis.end_date,vg_end_date);

Line 426: l_dm_status fv_invoice_statuses_all.status%TYPE ;

422: num_debt_eligible_int_offset NUMBER ;
423: num_debt_eligible_offset NUMBER ;
424: num_debt_eligible_X_servicing NUMBER ;
425:
426: l_dm_status fv_invoice_statuses_all.status%TYPE ;
427: l_pay_schedule_id NUMBER;
428: l_dm_due_date DATE;
429: l_count NUMBER ;
430: l_customer_trx_id NUMBER;

Line 644: FROM fv_invoice_statuses_all fvis

640: IF (recs.class = 'INV' ) then
641: BEGIN
642: SELECT count(*)
643: INTO l_count
644: FROM fv_invoice_statuses_all fvis
645: WHERE fvis.customer_trx_id = recs.customer_trx_id
646: AND fvis.status = 'CROSS';
647: --AND l_end_date BETWEEN fvis.start_date AND fvis.end_date;
648: -- may need to add above check in case a bug is logged .

Line 1241: --l_dm_status fv_invoice_statuses_all.status%TYPE := '' ;

1237: num_SECC_1H NUMBER ;
1238: num_SECC_1I NUMBER ;
1239: num_SECC_1J NUMBER ;
1240:
1241: --l_dm_status fv_invoice_statuses_all.status%TYPE := '' ;
1242: --l_pay_schedule_id NUMBER;
1243: --l_dm_due_date DATE;
1244: --l_count NUMBER ;
1245: