41:
42: SELECT
43: FND_DATE.CANONICAL_TO_DATE(P_START_DATE),
44: FND_DATE.CANONICAL_TO_DATE(P_END_DATE),
45: FND_NUMBER.CANONICAL_TO_NUMBER(P_LEDGER_ID),
46: FND_DATE.CANONICAL_TO_DATE(P_START_UPDATE_DATE),
47: FND_DATE.CANONICAL_TO_DATE(P_END_UPDATE_DATE)
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
44: FND_DATE.CANONICAL_TO_DATE(P_END_DATE),
45: FND_NUMBER.CANONICAL_TO_NUMBER(P_LEDGER_ID),
46: FND_DATE.CANONICAL_TO_DATE(P_START_UPDATE_DATE),
47: FND_DATE.CANONICAL_TO_DATE(P_END_UPDATE_DATE)
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
45: FND_NUMBER.CANONICAL_TO_NUMBER(P_LEDGER_ID),
46: FND_DATE.CANONICAL_TO_DATE(P_START_UPDATE_DATE),
47: FND_DATE.CANONICAL_TO_DATE(P_END_UPDATE_DATE)
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
53: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_VALUE)
46: FND_DATE.CANONICAL_TO_DATE(P_START_UPDATE_DATE),
47: FND_DATE.CANONICAL_TO_DATE(P_END_UPDATE_DATE)
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
53: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_VALUE)
54: INTO
47: FND_DATE.CANONICAL_TO_DATE(P_END_UPDATE_DATE)
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
53: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_VALUE)
54: INTO
55: H_START_DATE,
48: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_ID),
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
53: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_VALUE)
54: INTO
55: H_START_DATE,
56: H_END_DATE,
49: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_DOC_VALUE),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),
52: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_ID),
53: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_SUB_DOC_VALUE)
54: INTO
55: H_START_DATE,
56: H_END_DATE,
57: H_SET_OF_BOOKS_ID,