DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on DUAL

Line 831: -- procedure to create report header for each individual report

827: RETURN NULL;
828:
829: END CHECK_DATE_ACCRUED_TILL;
830:
831: -- procedure to create report header for each individual report
832: PROCEDURE report_header(p_sob_name IN VARCHAR2
833: ,p_org_name IN VARCHAR2
834: ,p_accrual_date IN DATE
835: ,p_batch_name IN VARCHAR2

Line 967: l_string := 'SELECT '||'''N'''||' FROM DUAL WHERE '|| l_string;

963: ||l_rule.relational_op_meaning||' '||l_rule.right_operand_literal||' '||l_rule.right_parentheses_meaning;
964: END LOOP;
965: CLOSE accrual_rule_csr;
966:
967: l_string := 'SELECT '||'''N'''||' FROM DUAL WHERE '|| l_string;
968: EXECUTE IMMEDIATE l_string INTO x_result;
969:
970: EXCEPTION
971: WHEN NO_DATA_FOUND THEN

Line 1162: FROM dual;

1158: AND con.jtot_object1_code = cso.jtot_object_code;
1159:
1160: CURSOR l_fin_sys_parms_csr IS
1161: SELECT mo_global.get_current_org_id()
1162: FROM dual;
1163:
1164: -- Get Receivables Transaction Type
1165: CURSOR l_cust_trx_type_csr IS
1166: SELECT ctt.cust_trx_type_id

Line 10204: from dual ;

10200:
10201: -- Select sequence for marking processes
10202: select okl_opp_seq.nextval
10203: into l_seq_next
10204: from dual ;
10205:
10206: -- mark records for processing
10207: for chk_update_header_csr_rec in chk_update_header_csr loop
10208: