APPS.JAI_AP_IL_ORG_PKG dependencies on DUAL

Line 75: select 1 into l_invoice_id from dual

71: Begin
72: --deleted by eric for bug#6787209 on Feb 15,2008 begin
73: ------------------------------------------------------------------
74: /*
75: select 1 into l_invoice_id from dual
76: where not exists ( select invoice_id from jai_ap_tds_invoices where invoice_id = P_INVOICE_ID ); -- :inv_sum_folder.invoice_id
77: */
78: ------------------------------------------------------------------
79: --deleted by eric for bug#6787209 on Feb 15,2008 end

Line 122: select 1 into v_misc_line from dual

118: FUNCTION FUN_MISC_LINE (P_INVOICE_ID NUMBER,P_LOOKUP_CODE VARCHAR2,P_LINE_NUMBER NUMBER ) RETURN BOOLEAN IS
119: v_misc_line number(10);
120: BEGIN
121: Begin
122: select 1 into v_misc_line from dual
123: where exists (select 1 from ap_invoice_lines ap, jai_ap_invoice_lines jap
124: where jap.invoice_id = P_INVOICE_ID --:INV_SUM_FOLDER.INVOICE_ID
125: and jap.line_type_lookup_code = P_LOOKUP_CODE --:LINE_SUM_FOLDER.LINE_TYPE_LOOKUP_CODE
126: and jap.invoice_line_number = P_LINE_NUMBER --:LINE_SUM_FOLDER.LINE_NUMBER

Line 156: select 1 into v_check from dual

152: FUNCTION FUN_MISC_PO (P_INVOICE_ID NUMBER) RETURN BOOLEAN IS
153: v_check number(10);
154: BEGIN
155: Begin
156: select 1 into v_check from dual
157: where exists ( select 1 from jai_ap_invoice_lines jp where jp.invoice_id = P_INVOICE_ID and line_type_lookup_code ='MISCELLANEOUS' );
158: Exception
159: When no_data_found then
160: v_check := 0;