APPS.PJI_TIME_C dependencies on GL_PERIODS

Line 284: FROM gl_periods

280: , period_num
281: , period_name
282: , start_date
283: , end_date
284: FROM gl_periods
285: WHERE 1=1
286: AND period_set_name = g_period_set_name
287: AND period_type = g_period_type
288: AND adjustment_period_flag='N'

Line 596: FROM gl_periods

592: , period_num
593: , period_name
594: , start_date
595: , end_date
596: FROM gl_periods
597: WHERE 1=1
598: AND period_set_name = p_period_set_name
599: AND period_type = p_period_type
600: AND adjustment_period_flag='N'

Line 1560: -- p_period_set_name - GL periodset name to extract

1556: -- PUBLIC PROCEDURE load
1557: -- This is a public procedure that extracts
1558: -- GL period definitions into time summary tables.
1559: -- parameters :
1560: -- p_period_set_name - GL periodset name to extract
1561: -- p_period_type - GL periodset name to extract
1562: -- x_return_status - Standard return status:
1563: -- Success = Fnd_Api.G_RET_STS_SUCCESS
1564: -- Error = Fnd_Api.G_RET_STS_ERROR

Line 1561: -- p_period_type - GL periodset name to extract

1557: -- This is a public procedure that extracts
1558: -- GL period definitions into time summary tables.
1559: -- parameters :
1560: -- p_period_set_name - GL periodset name to extract
1561: -- p_period_type - GL periodset name to extract
1562: -- x_return_status - Standard return status:
1563: -- Success = Fnd_Api.G_RET_STS_SUCCESS
1564: -- Error = Fnd_Api.G_RET_STS_ERROR
1565: -- Unexp Error = G_RET_Fnd_Api.STS_UNEXP_ERROR

Line 1775: select distinct gl.period_set_name, gl.period_type from gl_periods gl

1771: l_name_row number;
1772: l_max_cal_name number;
1773:
1774: cursor new_cal is
1775: select distinct gl.period_set_name, gl.period_type from gl_periods gl
1776: minus
1777: select distinct cal.period_set_name, cal.period_type from pa_time_cal_name cal;
1778:
1779: begin