APPS.XTR_FPS2_P dependencies on XTR_JOURNALS

Line 1560: from xtr_journals

1556:
1557: /********* cursor below added by Ilavenil for witholding tax project *********/
1558: cursor last_intset_date is
1559: select nvl(max(journal_date), p_start_date)
1560: from xtr_journals
1561: where deal_number = p_deal_no
1562: and amount_type in ('INTSET','TAX') -- Ilavenil modified for witholding tax
1563: union
1564: /********* Ilavenil modified for witholding tax *********/

Line 1566: from xtr_journals a,

1562: and amount_type in ('INTSET','TAX') -- Ilavenil modified for witholding tax
1563: union
1564: /********* Ilavenil modified for witholding tax *********/
1565: select nvl(max(b.maturity_date), p_start_date)
1566: from xtr_journals a,
1567: xtr_rollover_transactions b
1568: where b.company_code =p_company
1569: and b.deal_number = p_deal_no
1570: and b.tax_settled_reference is not null

Line 1601: from xtr_journals

1597:
1598:
1599: cursor check_jrnl_done is
1600: select nvl(max(journal_date), p_start_date)
1601: from xtr_journals
1602: where deal_number = p_deal_no
1603: and amount_type in ('INTSET','TAX')
1604: union
1605: select nvl(max(b.maturity_date), p_start_date)

Line 1606: from xtr_journals a,

1602: where deal_number = p_deal_no
1603: and amount_type in ('INTSET','TAX')
1604: union
1605: select nvl(max(b.maturity_date), p_start_date)
1606: from xtr_journals a,
1607: xtr_rollover_transactions b
1608: where b.company_code = p_company
1609: and b.deal_number = p_deal_no
1610: and b.tax_settled_reference is not null