eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_SRS_INCREMENTOR_API dependencies on GL_ALLOC_FORMULA_LINES

Line 877: gl_alloc_formula_lines al,

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
881: AND al.allocation_formula_id = af.allocation_formula_id

Line 903: gl_alloc_formula_lines al,

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
907: AND al.allocation_formula_id = af.allocation_formula_id

Line 1004: gl_alloc_formula_lines al,

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
1008: AND al.allocation_formula_id = af.allocation_formula_id

Line 1032: gl_alloc_formula_lines al,

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
1036: AND al.allocation_formula_id = af.allocation_formula_id

Line 1279: gl_alloc_formula_lines afl,

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
1283: AND afl.allocation_formula_id = af.allocation_formula_id

Line 1296: gl_alloc_formula_lines afl,

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
1300: AND afl.allocation_formula_id = af.allocation_formula_id