DBA Data[Home] [Help]

APPS.EGO_PUB_HIST_PURGE_PKG dependencies on FND_DATE

Line 69: l_from_date := FND_DATE.canonical_to_date(p_from_date);

65:
66: BEGIN
67:
68: /* Change into Date format for passed in Date Range*/
69: l_from_date := FND_DATE.canonical_to_date(p_from_date);
70: l_to_date := FND_DATE.canonical_to_date(p_to_date);
71:
72: l_batch_sql := ' SELECT DISTINCT hdr.Batch_id
73: FROM EGO_PUB_BAT_HDR_B hdr, EGO_PUB_BAT_STATUS_B status

Line 70: l_to_date := FND_DATE.canonical_to_date(p_to_date);

66: BEGIN
67:
68: /* Change into Date format for passed in Date Range*/
69: l_from_date := FND_DATE.canonical_to_date(p_from_date);
70: l_to_date := FND_DATE.canonical_to_date(p_to_date);
71:
72: l_batch_sql := ' SELECT DISTINCT hdr.Batch_id
73: FROM EGO_PUB_BAT_HDR_B hdr, EGO_PUB_BAT_STATUS_B status
74: WHERE hdr.batch_id= status.batch_id ';