DBA Data[Home] [Help]

APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_DSO_SETUP

Line 3035: fii_ar_dso_setup dso

3031: decode(sch.class,'DEP','Y','N') unapplied_deposit_flag,
3032: 'Transaction' action,
3033: sch.actual_date_closed
3034: from fii_ar_pmt_schedules_f sch,
3035: fii_ar_dso_setup dso
3036: where sch.class <> 'PMT'
3037: and dso.dso_group='TC'
3038: and dso.dso_type = sch.class
3039:

Line 3152: fii_ar_dso_setup schdso,

3148: 'Adjustment' action,
3149: sch.actual_date_closed
3150: from fii_ar_adjustments_f adj,
3151: fii_ar_pmt_schedules_f sch,
3152: fii_ar_dso_setup schdso,
3153: fii_ar_dso_setup adjdso
3154: where adj.payment_schedule_id = sch.payment_schedule_id
3155: and sch.class <> 'PMT'
3156: and schdso.dso_group='TC'

Line 3153: fii_ar_dso_setup adjdso

3149: sch.actual_date_closed
3150: from fii_ar_adjustments_f adj,
3151: fii_ar_pmt_schedules_f sch,
3152: fii_ar_dso_setup schdso,
3153: fii_ar_dso_setup adjdso
3154: where adj.payment_schedule_id = sch.payment_schedule_id
3155: and sch.class <> 'PMT'
3156: and schdso.dso_group='TC'
3157: and schdso.dso_type = sch.class

Line 7686: fii_ar_dso_setup dso,

7682: decode(sch.class,'DEP','Y','N') unapplied_deposit_flag,
7683: 'Transaction' action,
7684: sch.actual_date_closed
7685: from fii_ar_pmt_schedules_f sch,
7686: fii_ar_dso_setup dso,
7687: fii_ar_paysch_merge_gt gt
7688: where sch.class <> 'PMT'
7689: and dso.dso_group='TC'
7690: and dso.dso_type = sch.class

Line 7804: fii_ar_dso_setup schdso,

7800: 'Adjustment' action,
7801: sch.actual_date_closed
7802: from fii_ar_adjustments_f adj,
7803: fii_ar_pmt_schedules_f sch,
7804: fii_ar_dso_setup schdso,
7805: fii_ar_dso_setup adjdso,
7806: FII_AR_PAYSCH_MERGE_GT gt
7807: where adj.payment_schedule_id = sch.payment_schedule_id
7808: and sch.class <> 'PMT'

Line 7805: fii_ar_dso_setup adjdso,

7801: sch.actual_date_closed
7802: from fii_ar_adjustments_f adj,
7803: fii_ar_pmt_schedules_f sch,
7804: fii_ar_dso_setup schdso,
7805: fii_ar_dso_setup adjdso,
7806: FII_AR_PAYSCH_MERGE_GT gt
7807: where adj.payment_schedule_id = sch.payment_schedule_id
7808: and sch.class <> 'PMT'
7809: and schdso.dso_group='TC'