DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on DUAL

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

717: RETURN NULL;
718:
719: END CHECK_DATE_ACCRUED_TILL;
720:
721: -- procedure to create report header for each individual report
722: PROCEDURE report_header(p_sob_name IN VARCHAR2
723: ,p_org_name IN VARCHAR2
724: ,p_accrual_date IN DATE
725: ,p_batch_name IN VARCHAR2

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

853: ||l_rule.relational_op_meaning||' '||l_rule.right_operand_literal||' '||l_rule.right_parentheses_meaning;
854: END LOOP;
855: CLOSE accrual_rule_csr;
856:
857: l_string := 'SELECT '||'''N'''||' FROM DUAL WHERE '|| l_string;
858: EXECUTE IMMEDIATE l_string INTO x_result;
859:
860: EXCEPTION
861: WHEN NO_DATA_FOUND THEN

Line 1052: FROM dual;

1048: AND con.jtot_object1_code = cso.jtot_object_code;
1049:
1050: CURSOR l_fin_sys_parms_csr IS
1051: SELECT mo_global.get_current_org_id()
1052: FROM dual;
1053:
1054: -- Get Receivables Transaction Type
1055: CURSOR l_cust_trx_type_csr IS
1056: SELECT ctt.cust_trx_type_id

Line 9208: from dual ;

9204:
9205: -- Select sequence for marking processes
9206: select okl_opp_seq.nextval
9207: into l_seq_next
9208: from dual ;
9209:
9210: -- mark records for processing
9211: for chk_update_header_csr_rec in chk_update_header_csr loop
9212: