APPS.PMI_BUILD_PROD_SUM dependencies on PMI_GL_TIME_V

Line 26: from PMI_GL_TIME_V a,PMI_GL_TIME_V b

22: a.period_start_date cur_start_date,
23: a.period_end_Date cur_end_Date,
24: b.period_start_date last_start_date,
25: b.period_end_Date last_end_date
26: from PMI_GL_TIME_V a,PMI_GL_TIME_V b
27: where a.set_of_books_name = b.set_of_books_name and
28: sysdate between a.period_start_date and a.period_end_Date AND
29: p_last_run_date between b.period_start_date and b.period_end_Date
30: ) d,

Line 31: PMI_GL_TIME_V c,

27: where a.set_of_books_name = b.set_of_books_name and
28: sysdate between a.period_start_date and a.period_end_Date AND
29: p_last_run_date between b.period_start_date and b.period_end_Date
30: ) d,
31: PMI_GL_TIME_V c,
32: GL_PLCY_MST gpm
33: where c.set_of_books_name = d.set_of_books_name
34: and gpm.set_of_books_name = c.set_of_books_name
35: and c.period_start_date >= d.last_start_date