DBA Data[Home] [Help]

APPS.JA_JAIN57F4_XMLP_PKG dependencies on JAI_PO_OSP_HDRS

Line 23: JAI_PO_OSP_HDRS J57F4

19: SELECT
20: FORM_ID,
21: PRINT_CNT
22: FROM
23: JAI_PO_OSP_HDRS J57F4
24: WHERE TRUNC(J57F4.ISSUE_DATE) <= NVL(P_TO_DATE
25: ,TRUNC(SYSDATE))
26: AND TRUNC(J57F4.ISSUE_DATE) >= TRUNC(NVL(P_FROM_DATE
27: ,TRUNC(J57F4.ISSUE_DATE)))

Line 45: JAI_PO_OSP_HDRS

41: V_COUNT := NVL(C_CNT_UPD.PRINT_CNT
42: ,0) + 1;
43: V_FORM_ID := C_CNT_UPD.FORM_ID;
44: UPDATE
45: JAI_PO_OSP_HDRS
46: SET
47: PRINT_CNT = V_COUNT
48: ,PRINT_ORIGINAL = 'N'
49: ,PRINT_DUPLICATE = 'N'