DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on DUAL

Line 581: FROM DUAL

577: , p_module => v_module);
578: BEGIN
579: SELECT 'Y'
580: INTO v_mapping_flag
581: FROM DUAL
582: WHERE EXISTS
583: (SELECT 'X'
584: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
585: XLA_MERGE_SEG_MAPS_GT gt,

Line 797: FROM DUAL

793: , p_module => v_module);
794: BEGIN
795: SELECT 'Y'
796: INTO v_dummy
797: FROM DUAL
798: WHERE EXISTS
799: (SELECT 'Ledger without access'
800: FROM XLA_LEDGER_OPTIONS opt,
801: XLA_LEDGER_RELATIONSHIPS_V rs,

Line 3096: from dual

3092: ,'A'
3093: ,null
3094: ,'N'
3095: ,'Other'
3096: from dual
3097: where p_array_merge_option(i) = 'TRANSFER'
3098: AND p_array_ledger_id(i) in
3099: (select ledger_id from xla_ae_lines_gt);
3100:

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

3707: ,p_array_mau => v_array_mau
3708: ,p_array_rounding_rule=> v_array_rounding_rule_code);
3709:
3710: IF(p_accounting_mode = 'F' AND v_batch_id is null) THEN
3711: SELECT xla_accounting_batches_s.NEXTVAL INTO v_batch_id FROM DUAL;
3712: IF (C_LEVEL_STATEMENT>= g_log_level)
3713: THEN
3714: trace( p_msg => 'Getting the batch id:'||to_char(v_batch_id)
3715: , p_level => C_LEVEL_STATEMENT