APPS.FII_AR_REVENUE_B_C dependencies on GL_PERIOD_STATUSES

Line 64: FROM gl_period_statuses ps,

60: CURSOR c_non_upgraded_ledgers IS
61: SELECT DISTINCT
62: s.ledger_id,
63: s.name
64: FROM gl_period_statuses ps,
65: gl_ledgers_public_v s,
66: fa_deprn_periods dp,
67: fa_book_controls bc,
68: (SELECT DISTINCT slga.ledger_id

Line 87: FROM gl_period_statuses ps,

83: CURSOR c_non_upgraded_ledgers IS
84: SELECT DISTINCT
85: s.ledger_id,
86: s.name
87: FROM gl_period_statuses ps,
88: gl_ledgers_public_v s,
89: (SELECT DISTINCT slga.ledger_id
90: FROM fii_slg_assignments slga,
91: fii_source_ledger_groups fslg

Line 105: FROM gl_period_statuses ps,

101: CURSOR c_non_upgraded_ledgers IS
102: SELECT DISTINCT
103: s.ledger_id,
104: s.name
105: FROM gl_period_statuses ps,
106: gl_ledgers_public_v s,
107: (SELECT DISTINCT slga.ledger_id
108: FROM fii_slg_assignments slga,
109: fii_source_ledger_groups fslg

Line 3958: FROM gl_period_statuses stu,

3954: IF l_last_start_date1 IS NOT NULL THEN
3955: l_last_start_date := l_last_start_date1;
3956: SELECT trunc(min(stu.start_date))
3957: INTO l_gl_from_date1
3958: FROM gl_period_statuses stu,
3959: fii_slg_assignments slga,
3960: fii_source_ledger_groups fslg
3961: WHERE slga.ledger_id = stu.set_of_books_id
3962: AND slga.source_ledger_group_id = fslg.source_ledger_group_id

Line 4012: FROM gl_period_statuses stu,

4008: l_last_period_to2);
4009: l_last_start_date := LEAST (l_last_start_date2, l_last_period_to2);
4010: SELECT trunc(min(stu.start_date))
4011: INTO l_gl_from_date2
4012: FROM gl_period_statuses stu,
4013: fii_slg_assignments slga,
4014: fii_source_ledger_groups fslg
4015: WHERE slga.ledger_id = stu.set_of_books_id
4016: AND slga.source_ledger_group_id = fslg.source_ledger_group_id