eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNRX_RENT_LES dependencies on DUAL

Line 687: into v_no_of_months from dual;

683: select MONTHS_BETWEEN(LAST_DAY(ADD_MONTHS(V_LEASE_TERM_DATE,-1)),LAST_DAY(V_LEASE_COM_DATE)) +
684: ROUND(TO_CHAR(TO_DATE(V_LEASE_TERM_DATE,'DD/MM/YY'),'DD')/TO_CHAR(TO_DATE(LAST_DAY(V_LEASE_TERM_DATE),'DD/MM/YY'),'DD'),3)
685: + ROUND((TO_CHAR(TO_DATE(LAST_DAY(V_LEASE_COM_DATE),'DD/MM/YY'),'DD')-TO_CHAR(TO_DATE(V_LEASE_COM_DATE,'DD/MM/YY'),'DD')+1)/
686: TO_CHAR(TO_DATE(LAST_DAY(V_LEASE_COM_DATE),'DD/MM/YY'),'DD'),3)
687: into v_no_of_months from dual;
688:
689: ELSIF V_PRORATION_RULE IN ( 365, 360 ) THEN
690: IF v_lease_term_date = v_lease_com_date THEN
691: SELECT ROUND(1/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

Line 691: SELECT ROUND(1/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

687: into v_no_of_months from dual;
688:
689: ELSIF V_PRORATION_RULE IN ( 365, 360 ) THEN
690: IF v_lease_term_date = v_lease_com_date THEN
691: SELECT ROUND(1/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
692: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') =1
693: AND LAST_DAY(v_lease_term_date) = v_lease_term_date THEN
694: SELECT ROUND(MONTHS_BETWEEN(v_lease_term_date,v_lease_com_date),0) INTO v_no_of_months FROM dual;
695: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') =1 AND

Line 694: SELECT ROUND(MONTHS_BETWEEN(v_lease_term_date,v_lease_com_date),0) INTO v_no_of_months FROM dual;

690: IF v_lease_term_date = v_lease_com_date THEN
691: SELECT ROUND(1/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
692: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') =1
693: AND LAST_DAY(v_lease_term_date) = v_lease_term_date THEN
694: SELECT ROUND(MONTHS_BETWEEN(v_lease_term_date,v_lease_com_date),0) INTO v_no_of_months FROM dual;
695: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') =1 AND
696: TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') 697: SELECT ROUND(MONTHS_BETWEEN(LAST_DAY(ADD_MONTHS(v_lease_term_date,-1)),v_lease_com_date),0)
698: +ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd'))/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

Line 698: +ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd'))/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

694: SELECT ROUND(MONTHS_BETWEEN(v_lease_term_date,v_lease_com_date),0) INTO v_no_of_months FROM dual;
695: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') =1 AND
696: TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') 697: SELECT ROUND(MONTHS_BETWEEN(LAST_DAY(ADD_MONTHS(v_lease_term_date,-1)),v_lease_com_date),0)
698: +ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd'))/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
699: ELSIF LAST_DAY(v_lease_term_date) =v_lease_term_date AND
700: TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') < TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'mmyy') THEN
701: SELECT MONTHS_BETWEEN(v_lease_term_date,LAST_DAY(v_lease_com_date))+
702: ROUND((TO_CHAR(TO_DATE(LAST_DAY(v_lease_com_date),'dd/mm/yy'),'dd')

Line 703: -TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd')+1)/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

699: ELSIF LAST_DAY(v_lease_term_date) =v_lease_term_date AND
700: TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') < TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'mmyy') THEN
701: SELECT MONTHS_BETWEEN(v_lease_term_date,LAST_DAY(v_lease_com_date))+
702: ROUND((TO_CHAR(TO_DATE(LAST_DAY(v_lease_com_date),'dd/mm/yy'),'dd')
703: -TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd')+1)/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
704: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') =TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'mmyy') THEN
705: SELECT ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd') - TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') +1)/
706: (V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
707: ELSE

Line 706: (V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

702: ROUND((TO_CHAR(TO_DATE(LAST_DAY(v_lease_com_date),'dd/mm/yy'),'dd')
703: -TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd')+1)/(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
704: ELSIF TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'mmyy') =TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'mmyy') THEN
705: SELECT ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd') - TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd') +1)/
706: (V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
707: ELSE
708: SELECT ROUND(MONTHS_BETWEEN(LAST_DAY(ADD_MONTHS(v_lease_term_date,-1)),LAST_DAY(v_lease_com_date)),0)
709: +ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd'))/(V_PRORATION_RULE/12),3)
710: + ROUND((TO_CHAR(TO_DATE(LAST_DAY(v_lease_com_date),'dd/mm/yy'),'dd')-TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd')+1)

Line 711: /(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;

707: ELSE
708: SELECT ROUND(MONTHS_BETWEEN(LAST_DAY(ADD_MONTHS(v_lease_term_date,-1)),LAST_DAY(v_lease_com_date)),0)
709: +ROUND((TO_CHAR(TO_DATE(v_lease_term_date,'dd/mm/yy'),'dd'))/(V_PRORATION_RULE/12),3)
710: + ROUND((TO_CHAR(TO_DATE(LAST_DAY(v_lease_com_date),'dd/mm/yy'),'dd')-TO_CHAR(TO_DATE(v_lease_com_date,'dd/mm/yy'),'dd')+1)
711: /(V_PRORATION_RULE/12),3) INTO v_no_of_months FROM dual;
712: END IF;
713:
714: END IF;
715: