DBA Data[Home] [Help]

APPS.GL_SRS_INCREMENTOR_API dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 878: gl_ledger_set_assignments lsa,

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
881: AND al.allocation_formula_id = af.allocation_formula_id
882: AND al.line_number IN (4, 5)

Line 904: gl_ledger_set_assignments ls,

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
907: AND al.allocation_formula_id = af.allocation_formula_id
908: AND al.line_number IN (4, 5)

Line 1005: gl_ledger_set_assignments lsa,

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
1008: AND al.allocation_formula_id = af.allocation_formula_id
1009: AND al.line_number IN (4, 5)

Line 1033: gl_ledger_set_assignments ls,

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
1036: AND al.allocation_formula_id = af.allocation_formula_id
1037: AND al.line_number IN (4, 5)

Line 1280: gl_ledger_set_assignments lsa,

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
1283: AND afl.allocation_formula_id = af.allocation_formula_id
1284: AND afl.line_number IN (4, 5)

Line 1297: gl_ledger_set_assignments lsa,

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
1300: AND afl.allocation_formula_id = af.allocation_formula_id
1301: AND afl.line_number IN (4, 5)