APPS.PA_PROGRESS_UTILS dependencies on PA_TIME_CAL_NAME

Line 13064: FROM PA_time_cal_name ftcn, /* Modified for bug 12979524 */

13060: END IF;
13061:
13062: IF l_cal_type = 'G' THEN
13063: SELECT ftcn.calendar_id INTO l_cal_id
13064: FROM PA_time_cal_name ftcn, /* Modified for bug 12979524 */
13065: pa_projects_all ppa,
13066: pa_implementations_all pia,
13067: gl_sets_of_books gsb
13068: WHERE ppa.project_id=p_project_id

Line 13075: FROM pa_time_cal_name ftcn, /* Modified for bug 12979524 */

13071: AND gsb.period_set_name=ftcn.period_set_name
13072: AND gsb.accounted_period_type=ftcn.period_type;
13073: ELSIF l_cal_type = 'P' THEN
13074: SELECT ftcn.calendar_id INTO l_cal_id
13075: FROM pa_time_cal_name ftcn, /* Modified for bug 12979524 */
13076: pa_projects_all ppa,
13077: pa_implementations_all pia
13078: WHERE ppa.project_id=p_project_id
13079: AND ppa.org_id=pia.org_id