APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on DUAL

Line 30: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'

26: , pd_as_of_date DATE
27: , p_process_message OUT NOCOPY varchar
28: , p_process_flag OUT NOCOPY varchar2
29: ) IS
30: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
31: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
32: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
33:
34: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS

Line 573: FROM dual;

569: ,1
570: ,SYSDATE
571: ,pd_as_of_date) - ln_reversal_num
572: INTO ld_new_as_of_date
573: FROM dual;
574: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 end*/
575: ELSE
576: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 begin*/
577: SELECT add_months(decode(sign(pd_as_of_date - SYSDATE)

Line 584: FROM dual;

580: ,1
581: ,SYSDATE
582: ,pd_as_of_date),-ln_reversal_num)
583: INTO ld_new_as_of_date
584: FROM dual;
585: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 end*/
586: END IF;
587: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_new_as_of_date='||ld_new_as_of_date);
588:

Line 608: SELECT add_months(r_standard_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;

604: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_standard_ap.invoice_id);
605: IF lv_reversal_unit = 'DAY' THEN
606: ld_grace_date := r_standard_ap.accounting_date + ln_reversal_num;
607: ELSE
608: SELECT add_months(r_standard_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;
609: END IF;--calculate grace date
610: lv_reversal_flag := 'Y';
611: IF r_standard_ap.payment_status_flag = 'Y' THEN
612: OPEN c_max_payment_date(r_standard_ap.invoice_id);

Line 708: SELECT add_months(r_matched_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;

704: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_matched_ap.invoice_id);
705: IF lv_reversal_unit = 'DAY' THEN
706: ld_grace_date := r_matched_ap.accounting_date + ln_reversal_num;
707: ELSE
708: SELECT add_months(r_matched_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;
709: END IF;--calculate grace date
710: lv_reversal_flag := 'Y';--Added by qiong for bug13435306
711: IF r_matched_ap.payment_status_flag = 'Y' THEN
712: OPEN c_max_payment_date(r_matched_ap.invoice_id);

Line 731: SELECT add_months(r_matched_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;

727:
728: IF lv_reversal_unit = 'DAY' THEN
729: ld_grace_date := r_matched_ap.accounting_date + ln_reversal_num;
730: ELSE
731: SELECT add_months(r_matched_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;
732: END IF;--calculate grace date
733:
734: lv_reversal_flag := 'Y';
735:

Line 817: SELECT add_months(r_ar.gl_date,ln_reversal_num) INTO ld_grace_date FROM dual;

813:
814: IF lv_reversal_unit = 'DAY' THEN
815: ld_grace_date := r_ar.gl_date + ln_reversal_num;
816: ELSE
817: SELECT add_months(r_ar.gl_date,ln_reversal_num) INTO ld_grace_date FROM dual;
818: END IF;--calculate grace date
819:
820: OPEN c_ar_applied_amount(r_ar.invoice_id,ld_grace_date);
821: FETCH c_ar_applied_amount INTO ln_paid_amt;

Line 993: SELECT add_months(pd_gl_date,ln_reversal_num) INTO ld_grace_date FROM dual;

989:
990: IF lv_reversal_unit = 'DAY' THEN
991: ld_grace_date := pd_gl_date + ln_reversal_num;
992: ELSE
993: SELECT add_months(pd_gl_date,ln_reversal_num) INTO ld_grace_date FROM dual;
994: END IF;--calculate grace date
995: RETURN ld_grace_date;
996: END get_reversal_date;
997: