APPS.PJI_TIME_C dependencies on PA_TIME_CAL_NAME

Line 1595: FROM pa_time_cal_name /* Modified for bug 12979524 */

1591: ELSIF p_period_set_name IS NOT NULL AND p_period_set_name IS NOT NULL THEN
1592: BEGIN
1593: SELECT calendar_id
1594: INTO l_calendar_id
1595: FROM pa_time_cal_name /* Modified for bug 12979524 */
1596: WHERE period_set_name = p_period_set_name
1597: AND period_type = p_period_type;
1598: EXCEPTION
1599: WHEN NO_DATA_FOUND THEN

Line 1618: FROM pa_time_cal_name cal /* Modified for bug 12979524 */

1614: , l_period_type_tbl
1615: , l_earliest_start_dates_tbl
1616: , l_latest_end_dates_tbl
1617: , l_cal_info_exists_tbl
1618: FROM pa_time_cal_name cal /* Modified for bug 12979524 */
1619: , PJI_TIME_CAL_EXTR_INFO info
1620: WHERE 1=1
1621: AND cal.calendar_id = info.calendar_id (+)
1622: AND cal.calendar_id = NVL(l_calendar_id,cal.calendar_id)

Line 1777: select distinct cal.period_set_name, cal.period_type from pa_time_cal_name cal;

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
1780:
1781: -- ---------------------------------------------------------

Line 1788: from pa_time_cal_name;

1784: l_name_row := 0;
1785:
1786: select nvl(max(calendar_id),0)
1787: into l_max_cal_name
1788: from pa_time_cal_name;
1789:
1790: -- ----------------------
1791: -- Populate Calendar Name Level
1792: -- ----------------------

Line 1795: insert into pa_time_cal_name

1791: -- Populate Calendar Name Level
1792: -- ----------------------
1793: FOR new_cal_rec IN new_cal LOOP
1794:
1795: insert into pa_time_cal_name
1796: (calendar_id,
1797: period_set_name,
1798: period_type,
1799: name,

Line 1826: , tabname => 'PA_TIME_CAL_NAME'

1822:
1823: if l_name_row > 0 then
1824:
1825: fnd_stats.gather_table_stats( ownname => 'PA'
1826: , tabname => 'PA_TIME_CAL_NAME'
1827: );
1828:
1829: end if;
1830: