APPS.POA_TIME_API dependencies on GL_PERIODS

Line 51: from gl_periods per

47:
48: cursor c1 is
49: select min(per.start_date),
50: max(per.end_date)
51: from gl_periods per
52: where per.period_set_name = g_period_set_name
53: and per.period_type = g_period_type
54: group by period_year, quarter_num
55: having nvl(g_poa_fixed_date, sysdate)

Line 62: from gl_periods per

58:
59: cursor c2 is
60: select min(per.start_date),
61: max(per.end_date)
62: from gl_periods per
63: where per.period_set_name = g_period_set_name
64: and per.period_type = g_period_type
65: group by period_year, quarter_num
66: having add_months(nvl(g_poa_fixed_date, sysdate), -12)

Line 73: from gl_periods per

69:
70: cursor c3 is
71: select min(per.start_date),
72: max(per.end_date)
73: from gl_periods per
74: where per.period_set_name = g_period_set_name
75: and per.period_type = g_period_type
76: group by period_year
77: having nvl(g_poa_fixed_date, sysdate)

Line 84: from gl_periods per

80:
81: cursor c4 is
82: select min(per.start_date),
83: max(per.end_date)
84: from gl_periods per
85: where per.period_set_name = g_period_set_name
86: and per.period_type = g_period_type
87: group by period_year
88: having add_months(nvl(g_poa_fixed_date, sysdate), -12)