APPS.JAI_FBT_SETTLEMENT_P dependencies on DUAL

Line 339: FROM dual

335:
336: -- Check if settled for this period
337: CURSOR check_settled IS
338: SELECT 1
339: FROM dual
340: WHERE EXISTS( SELECT 1
341: FROM jai_fbt_settlement
342: WHERE legal_entity_id = pn_legal_entity_id
343: AND period_start_date = ld_start_date

Line 404: dual;

400: TO_CHAR(ld_start_date,'MM')
401: INTO
402: lv_jan
403: FROM
404: dual;
405: -- get the return_generate_flag
406: IF (lv_jan = '01')
407: THEN
408: lv_return_generate_flag := 'Y';

Line 431: FROM dual;

427:
428: -- get the settlement id
429: SELECT jai_fbt_settlement_s.NEXTVAL
430: INTO ln_settlement_id
431: FROM dual;
432:
433: -- insert the data into the table jai_fbt_settlement
434: fbt_settlement_rec.legal_entity_id := pn_legal_entity_id;
435: fbt_settlement_rec.period_start_date := ld_start_date;

Line 474: FROM dual;

470: -- ap_invoice_lines_interface
471: -- get invoice id
472: SELECT ap_invoices_interface_s.nextval
473: INTO ln_invoice_id
474: FROM dual;
475:
476: -- get invoice num
477: -- SELECT 'FBT/Invoice/' || TO_CHAR(ld_end_date)
478: SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_end_date) -- Modified by jia for bug#7146038 on 2008/06/04

Line 480: FROM dual;

476: -- get invoice num
477: -- SELECT 'FBT/Invoice/' || TO_CHAR(ld_end_date)
478: SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_end_date) -- Modified by jia for bug#7146038 on 2008/06/04
479: INTO ln_invoice_num
480: FROM dual;
481:
482: -- get currency code
483: OPEN currency_code_cur;
484: FETCH currency_code_cur

Line 517: FROM dual;

513: -- ap_invoice_lines_interface
514: -- get invoice line id
515: SELECT ap_invoice_lines_interface_s.nextval
516: INTO ln_invoice_line_id
517: FROM dual;
518:
519: inv_lines_interface_rec.invoice_id := ln_invoice_id;
520: inv_lines_interface_rec.invoice_line_id := ln_invoice_line_id;
521: inv_lines_interface_rec.line_number := 1;