eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_CRDT_TRNSCTNS

Line 458: FROM igs_fi_crdt_trnsctns

454: effective_date,
455: credit_type,
456: description,
457: (-amount) amount -- Negate the amount since this is a Credit Transaction.
458: FROM igs_fi_crdt_trnsctns
459: WHERE person_id = cp_n_person_id
460: AND (cp_d_start_date IS NULL OR (TRUNC(effective_date) >= TRUNC(cp_d_start_date)))
461: AND TRUNC(effective_date) <= TRUNC(cp_d_cutoff_dt)
462: AND credit_activity_id IN (SELECT credit_activity_id

Line 566: FROM igs_fi_crdt_trnsctns

562: cp_d_start_date IN DATE,
563: cp_d_cutoff_dt IN DATE
564: ) IS
565: SELECT NVL (SUM (amount), 0) total_credit_amount
566: FROM igs_fi_crdt_trnsctns
567: WHERE person_id = cp_n_person_id
568: AND (cp_d_start_date IS NULL OR (TRUNC(effective_date) >= TRUNC(cp_d_start_date)))
569: AND TRUNC(effective_date) <= TRUNC(cp_d_cutoff_dt)
570: AND credit_activity_id IN (SELECT credit_activity_id