APPS.GL_SRS_INCREMENTOR_API dependencies on GL_RECURRING_HEADERS

Line 780: FROM gl_recurring_headers rh, gl_ledgers lgr

776: -- Check if ADB ledgers exist in the batch
777: BEGIN
778: SELECT lgr.ledger_id
779: into v_adb_ledger_id
780: FROM gl_recurring_headers rh, gl_ledgers lgr
781: WHERE rh.recurring_batch_id = v_batch_id
782: AND lgr.ledger_id = rh.ledger_id
783: AND lgr.enable_average_balances_flag = 'Y'
784: AND lgr.consolidation_ledger_flag = 'N'

Line 795: FROM gl_recurring_headers rh, gl_ledgers lgr

791: -- Check if consolidation ledgers exist in the batch
792: BEGIN
793: SELECT lgr.ledger_id
794: into v_con_ledger_id
795: FROM gl_recurring_headers rh, gl_ledgers lgr
796: WHERE rh.recurring_batch_id = v_batch_id
797: AND lgr.ledger_id = rh.ledger_id
798: AND lgr.enable_average_balances_flag = 'Y'
799: AND lgr.consolidation_ledger_flag = 'Y'

Line 1063: FROM gl_recurring_headers rh, gl_ledgers lgr

1059: -- Check if ADB ledgers exist in the batch
1060: BEGIN
1061: SELECT lgr.ledger_id
1062: into v_adb_ledger_id
1063: FROM gl_recurring_headers rh, gl_ledgers lgr
1064: WHERE rh.recurring_batch_id = current_bid
1065: AND lgr.ledger_id = rh.ledger_id
1066: AND lgr.enable_average_balances_flag = 'Y'
1067: AND lgr.consolidation_ledger_flag = 'N'

Line 1080: FROM gl_recurring_headers rh, gl_ledgers lgr

1076: -- Check if consolidation ledgers exist in the batch
1077: BEGIN
1078: SELECT lgr.ledger_id
1079: into v_con_ledger_id
1080: FROM gl_recurring_headers rh, gl_ledgers lgr
1081: WHERE rh.recurring_batch_id = current_bid
1082: AND lgr.ledger_id = rh.ledger_id
1083: AND lgr.enable_average_balances_flag = 'Y'
1084: AND lgr.consolidation_ledger_flag = 'Y'

Line 1272: FROM gl_recurring_headers

1268: WHERE allocation_set_id = x_batch_id;
1269:
1270: CURSOR rje_ledger(random_bid number) IS
1271: SELECT ledger_id
1272: FROM gl_recurring_headers
1273: WHERE recurring_batch_id = random_bid;
1274:
1275:
1276: CURSOR ma_ledger (random_bid number) IS