APPS.GMF_SUBLEDGER_PKG dependencies on DUAL

Line 672: INTO l_date_range_secs FROM DUAL;

668: AND g_num_req > 1
669: ) THEN --{
670:
671: SELECT (l_up_posting_end_date - l_up_posting_start_date)*24*60*60 /* Date range in seconds */
672: INTO l_date_range_secs FROM DUAL;
673:
674: IF l_date_range_secs <= 3600 THEN /* Date range less than one hour */
675: g_sub_mul_req := 'N';
676: ELSE

Line 817: SELECT TRUNC(l_date_range_secs/g_num_req) INTO l_secs FROM DUAL;

813: AND g_sub_mul_req = 'Y'
814: ) THEN
815:
816: /* Submit multiple requests for date ranges */
817: SELECT TRUNC(l_date_range_secs/g_num_req) INTO l_secs FROM DUAL;
818:
819: FOR i in 1 .. g_num_req
820: LOOP
821: IF l_check = 1 THEN

Line 1745: Select gem5_reference_no_s.NEXTVAL INTO l_subledger_ref_no From Dual;

1741: END;
1742: END IF;
1743:
1744: -- B 7203807
1745: Select gem5_reference_no_s.NEXTVAL INTO l_subledger_ref_no From Dual;
1746:
1747: /* insert the control record */
1748: INSERT INTO gl_subr_sta
1749: (