[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'