DBA Data[Home] [Help]

APPS.GL_SRS_INCREMENTOR_API dependencies on GL_ALLOC_FORMULAS

Line 876: FROM gl_alloc_formulas af,

872: -- Check if ADB ledgers exist in the batch
873: BEGIN
874: SELECT lgr.ledger_id
875: into v_adb_ledger_id
876: FROM gl_alloc_formulas af,
877: gl_alloc_formula_lines al,
878: gl_ledger_set_assignments lsa,
879: gl_ledgers lgr
880: WHERE af.allocation_batch_id = v_batch_id

Line 902: FROM gl_alloc_formulas af,

898: -- Check if consolidation ledgers exist in the batch
899: BEGIN
900: SELECT lgr.ledger_id
901: into v_con_ledger_id
902: FROM gl_alloc_formulas af,
903: gl_alloc_formula_lines al,
904: gl_ledger_set_assignments ls,
905: gl_ledgers lgr
906: WHERE af.allocation_batch_id = v_batch_id

Line 1003: FROM gl_alloc_formulas af,

999: -- Check if ADB ledgers exist in the batch
1000: BEGIN
1001: SELECT lgr.ledger_id
1002: into v_adb_ledger_id
1003: FROM gl_alloc_formulas af,
1004: gl_alloc_formula_lines al,
1005: gl_ledger_set_assignments lsa,
1006: gl_ledgers lgr
1007: WHERE af.allocation_batch_id = current_bid

Line 1031: FROM gl_alloc_formulas af,

1027: -- Check if consolidation ledgers exist in the batch
1028: BEGIN
1029: SELECT lgr.ledger_id
1030: into v_con_ledger_id
1031: FROM gl_alloc_formulas af,
1032: gl_alloc_formula_lines al,
1033: gl_ledger_set_assignments ls,
1034: gl_ledgers lgr
1035: WHERE af.allocation_batch_id = current_bid

Line 1278: FROM gl_alloc_formulas af,

1274:
1275:
1276: CURSOR ma_ledger (random_bid number) IS
1277: SELECT lgr.ledger_id
1278: FROM gl_alloc_formulas af,
1279: gl_alloc_formula_lines afl,
1280: gl_ledger_set_assignments lsa,
1281: gl_ledgers lgr
1282: WHERE af.allocation_batch_id = random_bid

Line 1295: FROM gl_alloc_formulas af,

1291: AND lgr.object_type_code = 'L';
1292:
1293: CURSOR mb_ledger (random_bid number)IS
1294: SELECT lgr.ledger_id
1295: FROM gl_alloc_formulas af,
1296: gl_alloc_formula_lines afl,
1297: gl_ledger_set_assignments lsa,
1298: gl_ledgers lgr
1299: WHERE af.allocation_batch_id = random_bid