APPS.JA_JAIN57PI_XMLP_PKG dependencies on JAI_PO_OSP_HDRS

Line 26: FROM JAI_PO_OSP_HDRS F3

22: --SRW.MESSAGE(1275,'REPORT VERSION IS 115.1 LAST MODIFIED DATE IS 17/11/2004 ');
23: BEGIN
24: IF TRUNC(P_FROM_DATE) IS NULL THEN
25: SELECT MIN( CREATION_DATE) INTO CP_FROM_DATE
26: FROM JAI_PO_OSP_HDRS F3
27: WHERE F3.ORGANIZATION_ID = P_ORGANIZATION_ID
28: AND F3.LOCATION_ID = NVL(P_LOCATION_ID,F3.LOCATION_ID);
29: ELSE
30: CP_FROM_DATE := TO_CHAR(P_FROM_DATE,'DD-MON-YY');