DBA Data[Home] [Help]

APPS.JE_REVERSE_SALES_LIST_PKG dependencies on FND_APPLICATION

Line 48: FROM fnd_application

44: ld_to_date DATE;
45: lv_cust_vat_reg_num VARCHAR2(30);
46: CURSOR c_period_range IS
47: SELECT ADD_MONTHS(TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS'),ROWNUM-1) PERIOD
48: FROM fnd_application
49: WHERE ROWNUM <=DECODE( ROUND(MONTHS_BETWEEN(TRUNC(TO_DATE(P_TO_DATE,'YYYY/MM/DD HH24:MI:SS')),
50: TRUNC(TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS')))),0,1, ROUND(MONTHS_BETWEEN(TRUNC(TO_DATE(P_TO_DATE,'YYYY/MM/DD HH24:MI:SS')),
51: TRUNC(TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS')))));
52: CURSOR c_customers IS