APPS.PA_DEDUCTIONS dependencies on DUAL

Line 130: select 'Y' from dual where not exists(select 1 from pa_deductions_all

126:
127: l_dctn_hdr g_dctn_hdrtbl;
128:
129: CURSOR C1(ded_id IN NUMBER) is
130: select 'Y' from dual where not exists(select 1 from pa_deductions_all
131: where deduction_req_id=ded_id);
132:
133: notexist VARCHAR2(1);
134:

Line 218: ,g_user_id FROM DUAL;

214: ,p_dctn_hdr(i).status
215: ,DECODE(p_dctn_hdr(i).ci_id, NULL,'M','C')
216: ,p_dctn_hdr(i).org_id
217: ,SYSDATE
218: ,g_user_id FROM DUAL;
219: p_return_status :='S';
220: End If;
221: END IF;
222: End Loop;

Line 362: ,p_dctn_dtl(i).description FROM DUAL WHERE p_dctn_dtl(i).status IS NULL;

358: ,p_dctn_dtl(i).expenditure_item_date
359: ,p_dctn_dtl(i).expenditure_item_date
360: ,SYSDATE
361: ,g_user_id
362: ,p_dctn_dtl(i).description FROM DUAL WHERE p_dctn_dtl(i).status IS NULL;
363:
364: End Loop;
365:
366: IF P_DEBUG_MODE = 'Y' THEN

Line 779: FROM DUAL WHERE EXISTS (

775: CURSOR C3(p_debit_memo_num PA_DEDUCTIONS_ALL.debit_memo_num%TYPE,
776: p_vendor_id PA_DEDUCTIONS_ALL.vendor_id%TYPE,
777: p_org_id PA_DEDUCTIONS_ALL.org_id%TYPE) is
778: SELECT 'N'
779: FROM DUAL WHERE EXISTS (
780: SELECT 1
781: FROM AP_INVOICES_ALL
782: WHERE invoice_num = p_debit_memo_num
783: AND vendor_id = p_vendor_id

Line 1502: FROM SYS.DUAL;

1498: 'APPROVED');
1499:
1500: SELECT AP_INVOICES_INTERFACE_S.nextval
1501: INTO l_int_invoice_id
1502: FROM SYS.DUAL;
1503:
1504: IF P_DEBUG_MODE = 'Y' THEN
1505: log_message ('Invoice_Id in interface table :'||l_int_invoice_id, g_api_name);
1506: END IF;

Line 1746: FROM sys.dual;

1742: log_message ('Before inserting lines into interface lines table', g_api_name);
1743:
1744: SELECT ap_invoice_lines_interface_s.nextval
1745: INTO l_invoice_line_id
1746: FROM sys.dual;
1747:
1748: IF P_DEBUG_MODE = 'Y' THEN
1749: log_message ('Invoice Line Id : '||l_invoice_line_id, g_api_name);
1750: END IF;

Line 1923: FROM DUAL;

1919: log_message ('In Import process', g_api_name);
1920:
1921: SELECT FND_GLOBAL.CONC_REQUEST_ID
1922: INTO p_conc_request_id
1923: FROM DUAL;
1924:
1925: IF P_DEBUG_MODE = 'Y' THEN
1926: log_message ('Conc request id'||p_conc_request_id, g_api_name);
1927: END IF;

Line 2204: FROM DUAL WHERE EXISTS (

2200: CURSOR C2(p_debit_memo_num PA_DEDUCTIONS_ALL.debit_memo_num%TYPE,
2201: p_org_id PA_DEDUCTIONS_ALL.org_id%TYPE,
2202: p_vendor_id PA_DEDUCTIONS_ALL.vendor_id%TYPE) IS
2203: SELECT 'N'
2204: FROM DUAL WHERE EXISTS (
2205: SELECT 1
2206: FROM AP_INVOICES_ALL
2207: WHERE invoice_num = p_debit_memo_num
2208: AND vendor_id = p_vendor_id

Line 2281: INTO l_next_number FROM sys.DUAL;

2277: END IF;
2278:
2279: LOOP
2280: SELECT PA_DEDUCTIONS_DM_S.nextval
2281: INTO l_next_number FROM sys.DUAL;
2282:
2283: OPEN C1(l_next_number,
2284: p_dctn_hdr(1).org_id,
2285: p_dctn_hdr(1).vendor_id,