APPS.JAI_RCV_RND_PKG dependencies on DUAL

Line 687: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;

683: -- incase error occured due to code between v_save_point_set = FALSE and v_save_point_set = TRUE
684: v_tot_processed_invoices := v_tot_processed_invoices + 1;
685:
686: v_statement_no := '1.4';
687: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;
688:
689: v_line_type_a_cnt := 0;
690: v_line_type_c_cnt := 0;
691: v_tot_lines_cnt := 0;

Line 1281: FROM dual;

1277: SELECT DECODE(i, 1, jai_constants.tax_type_exc_edu_cess, 2, jai_constants.tax_type_cvd_edu_cess) tax_type,
1278: DECODE(i, 1, v_rounded_dr_oth_amount.excise_edu_cess, 2, v_rounded_dr_oth_amount.cvd_edu_cess) dr_cess_amount,
1279: DECODE(i, 1, v_rounded_cr_oth_amount.excise_edu_cess, 2, v_rounded_cr_oth_amount.cvd_edu_cess) cr_cess_amount
1280: INTO v_tax_type, v_dr_amt, v_cr_amt
1281: FROM dual;
1282: */
1283:
1284: if i = 1 then
1285: v_tax_type := jai_constants.tax_type_exc_edu_cess;

Line 2402: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;

2398:
2399: v_tot_processed_invoices := v_tot_processed_invoices + 1;
2400:
2401: v_statement_no := '1.4';
2402: SELECT JAI_CMN_RG_ROUND_HDRS_S.nextval INTO v_rounding_id FROM dual;
2403:
2404: v_line_type_c_cnt := 0;
2405: v_tot_lines_cnt := 0;
2406: v_tot_amount := v_zero_record;