APPS.JAI_CMN_ST_FORMS_PKG dependencies on DUAL

Line 120: FROM dual

116: where invoice_id = p_invoice_id
117: and nvl(match_status_flag, 'N') <> 'A';*/
118: --commented the above and added the below by Sanjikum for Bug#4929400
119: SELECT 'Y'
120: FROM dual
121: WHERE exists (select '1'
122: from ap_invoice_distributions_all
123: where invoice_id = p_invoice_id
124: and nvl(match_status_flag, 'N') <> 'A');

Line 695: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;

691:
692:
693: if v_st_hdr_id is null then
694:
695: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;
696:
697: insert into JAI_CMN_STFORM_HDRS_ALL
698: (
699: st_hdr_id,

Line 798: /* select JAI_CMN_ST_FORM_DTLS_S.nextval into v_st_dtl_id from dual; */

794: end if;
795:
796: end if;
797: -- End 5763527
798: /* select JAI_CMN_ST_FORM_DTLS_S.nextval into v_st_dtl_id from dual; */
799:
800: v_rcv_transaction_id := null;
801:
802:

Line 1856: Also the code SELECT .nextval INTO FROM DUAL is modified to populate during INSERT

1852:
1853: 2. 13/02/2004 Vijay Shankar for bug # 3441533, FileVersion: 618.1
1854: v_hdr_record_exists variable which is used to check whether header is inserted or not is retaining its value
1855: in the loop. This is fixed by assigning NULL at the start of the loop so that it wont retain its value.
1856: Also the code SELECT .nextval INTO FROM DUAL is modified to populate during INSERT
1857: Statement. Usage of v_success variable is removed
1858:
1859: 3. 18/11/2008 JMEENA for bug#4932256 (FP 4913641)
1860: Issue: Debit Notes and Credit Notes are not considered for AR ST Forms tracking in AR