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.PSP_ARCHIVE_RETRIEVE dependencies on FND_DATE

Line 1600: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)

1596: , min (distribution_date)
1597: , max (distribution_date)
1598: FROM psp_distribution_interface pdi
1599: WHERE pdi.distribution_date
1600: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1601: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1602: AND business_group_id = l_business_group_id
1603: AND set_of_books_id = l_set_of_books_id
1604: AND NOT EXISTS ---- See is there is atleast one record that is falling out of the period specified OR not yet transferred for the batch selected above

Line 1601: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)

1597: , max (distribution_date)
1598: FROM psp_distribution_interface pdi
1599: WHERE pdi.distribution_date
1600: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1601: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1602: AND business_group_id = l_business_group_id
1603: AND set_of_books_id = l_set_of_books_id
1604: AND NOT EXISTS ---- See is there is atleast one record that is falling out of the period specified OR not yet transferred for the batch selected above
1605: (

Line 1612: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)

1608: FROM psp_distribution_interface pdi2
1609: WHERE pdi2.batch_name = pdi.batch_name
1610: AND (
1611: pdi2.distribution_date
1612: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1613: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1614: OR pdi2.status_code <> 'T'
1615: )
1616: )

Line 1613: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)

1609: WHERE pdi2.batch_name = pdi.batch_name
1610: AND (
1611: pdi2.distribution_date
1612: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1613: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1614: OR pdi2.status_code <> 'T'
1615: )
1616: )
1617: GROUP BY batch_name;

Line 1678: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)

1674: , suspense_auto_exp_type
1675: FROM psp_distribution_interface pdi
1676: WHERE pdi.batch_name LIKE p_batch_name
1677: AND pdi.distribution_date
1678: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1679: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1680: AND business_group_id = l_business_group_id
1681: AND set_of_books_id = l_set_of_books_id
1682: AND NOT EXISTS

Line 1679: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)

1675: FROM psp_distribution_interface pdi
1676: WHERE pdi.batch_name LIKE p_batch_name
1677: AND pdi.distribution_date
1678: BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1679: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1680: AND business_group_id = l_business_group_id
1681: AND set_of_books_id = l_set_of_books_id
1682: AND NOT EXISTS
1683: (

Line 1690: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)

1686: FROM psp_distribution_interface pdi2
1687: WHERE pdi2.batch_name = pdi.batch_name
1688: AND (
1689: pdi2.distribution_date
1690: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1691: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1692: OR pdi2.status_code <> 'T'
1693: )
1694: );

Line 1691: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)

1687: WHERE pdi2.batch_name = pdi.batch_name
1688: AND (
1689: pdi2.distribution_date
1690: NOT BETWEEN nvl (fnd_date.canonical_to_date (p_begin_date), hr_general.start_of_time)
1691: AND nvl (fnd_date.canonical_to_date (p_end_date), hr_general.end_of_time)
1692: OR pdi2.status_code <> 'T'
1693: )
1694: );
1695:

Line 1872: , fnd_date.canonical_to_date (p_begin_date)

1868: , batch_size
1869: , min_dist_date
1870: , max_dist_date)
1871: VALUES (l_request_id
1872: , fnd_date.canonical_to_date (p_begin_date)
1873: , fnd_date.canonical_to_date (p_end_date)
1874: , NULL
1875: , batch_name_rec.batch_name (j)
1876: , p_archival_code

Line 1873: , fnd_date.canonical_to_date (p_end_date)

1869: , min_dist_date
1870: , max_dist_date)
1871: VALUES (l_request_id
1872: , fnd_date.canonical_to_date (p_begin_date)
1873: , fnd_date.canonical_to_date (p_end_date)
1874: , NULL
1875: , batch_name_rec.batch_name (j)
1876: , p_archival_code
1877: , batch_name_rec.batch_size (j)