DBA Data[Home] [Help]

APPS.IGS_FI_PRC_HOLDS dependencies on IGS_FI_CR_TYPES

Line 209: igs_fi_cr_types crt

205: SELECT crd.credit_id,
206: crd.amount,
207: crd.effective_date
208: FROM igs_fi_credits crd,
209: igs_fi_cr_types crt
210: WHERE TRUNC(crd.effective_date) between (TRUNC(p_process_start_date) + 1) AND TRUNC(l_payment_due_date)
211: AND crd.status = 'CLEARED'
212: AND crd.party_id = p_person_id
213: AND crd.credit_type_id = crt.credit_type_id

Line 1720: igs_fi_cr_types crt

1716: SELECT crd.credit_id,
1717: crd.amount,
1718: crd.effective_date
1719: FROM igs_fi_credits crd,
1720: igs_fi_cr_types crt
1721: WHERE TRUNC(crd.effective_date) between
1722: (TRUNC(l_process_start_date) + 1 )and TRUNC(SYSDATE)
1723: AND crd.status = 'CLEARED'
1724: AND crd.party_id = p_person_id