DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on DUAL

Line 576: FROM DUAL

572: , p_module => v_module);
573: BEGIN
574: SELECT 'Y'
575: INTO v_mapping_flag
576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
580: XLA_MERGE_SEG_MAPS_GT gt,

Line 790: FROM DUAL

786: , p_module => v_module);
787: BEGIN
788: SELECT 'Y'
789: INTO v_dummy
790: FROM DUAL
791: WHERE EXISTS
792: (SELECT 'Ledger without access'
793: FROM XLA_LEDGER_OPTIONS opt,
794: XLA_LEDGER_RELATIONSHIPS_V rs,

Line 3078: from dual

3074: ,'A'
3075: ,null
3076: ,'N'
3077: ,'Other'
3078: from dual
3079: where p_array_merge_option(i) = 'TRANSFER'
3080: AND p_array_ledger_id(i) in
3081: (select ledger_id from xla_ae_lines_gt);
3082:

Line 3693: SELECT xla_accounting_batches_s.NEXTVAL INTO v_batch_id FROM DUAL;

3689: ,p_array_mau => v_array_mau
3690: ,p_array_rounding_rule=> v_array_rounding_rule_code);
3691:
3692: IF(p_accounting_mode = 'F' AND v_batch_id is null) THEN
3693: SELECT xla_accounting_batches_s.NEXTVAL INTO v_batch_id FROM DUAL;
3694: IF (C_LEVEL_STATEMENT>= g_log_level)
3695: THEN
3696: trace( p_msg => 'Getting the batch id:'||to_char(v_batch_id)
3697: , p_level => C_LEVEL_STATEMENT