39: RAISE;*/NULL;
40: END;
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)
40: END;
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),
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),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
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),
50: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_FROM),
51: -- FND_NUMBER.CANONICAL_TO_NUMBER(:P_AMOUNT_TO),