APPS.GL_MC_INFO dependencies on DUAL

Line 746: FROM dual;

742: x_ledger_list(i).ledger_name,
743: x_ledger_list(i).ledger_short_name,
744: x_ledger_list(i).ledger_currency,
745: x_ledger_list(i).ledger_category
746: FROM dual;
747: END LOOP; -- FOR LOOP
748:
749: RETURN TRUE;
750:

Line 797: FROM dual;

793: SELECT l_rec_col.legal_entity_id(i),
794: l_rec_col.legal_entity_name(i)
795: INTO x_le_list(i).legal_entity_id,
796: x_le_list(i).legal_entity_name
797: FROM dual;
798: END LOOP; -- FOR LOOP
799:
800: RETURN TRUE;
801:

Line 904: FROM dual;

900: SELECT l_rec_col.legal_entity_id(i),
901: l_rec_col.legal_entity_name(i)
902: INTO x_le_list(i).legal_entity_id,
903: x_le_list(i).legal_entity_name
904: FROM dual;
905: END LOOP; -- FOR LOOP
906:
907: RETURN TRUE;
908:

Line 1094: FROM dual;

1090: l_rec_col.legal_entity_name(i)
1091: INTO x_bsv_list(i).bal_seg_value,
1092: x_bsv_list(i).legal_entity_id,
1093: x_bsv_list(i).legal_entity_name
1094: FROM dual;
1095: END LOOP; -- FOR LOOP
1096:
1097: RETURN TRUE;
1098:

Line 1604: FROM dual;

1600: n_ledger_list(i).r_precision,
1601: n_ledger_list(i).r_mau,
1602: n_ledger_list(i).r_sob_type,
1603: n_ledger_list(i).r_sob_user_type
1604: FROM dual;
1605:
1606: END LOOP; /* FOR LOOP */
1607: END IF; -- IF l_alc_enabled = 'N' THEN
1608: END IF; -- IF l_alc_ledger_type = 'NONE'

Line 2073: FROM dual;

2069: n_ledger_list(i).r_precision,
2070: n_ledger_list(i).r_mau,
2071: n_ledger_list(i).r_sob_type,
2072: n_ledger_list(i).r_sob_user_type
2073: FROM dual;
2074: END LOOP; -- FOR LOOP
2075: END IF; -- IF (l_num_rec = 0) THEN
2076: END IF; -- IF l_ledger_category = 'ALC' OR l_ledger_category = 'NONE' THEN
2077: END;

Line 2333: FROM dual

2329:
2330: BEGIN
2331: SELECT 'Already Populated'
2332: INTO l_status
2333: FROM dual
2334: WHERE EXISTS
2335: (SELECT 'x'
2336: FROM gl_ledger_bsv_gt
2337: WHERE ledger_id = n_ledger_id);