APPS.PA_SWEEPER dependencies on PA_PERIODS_ALL

Line 40: from pa_periods_all pda

36: and gps.adjustment_period_flag = 'N';
37: ELSIF p_time_phase_code = 'P' then
38: select pda.start_date
39: into l_st_date
40: from pa_periods_all pda
41: where trunc(pda.start_date) <= trunc(p_pa_date)
42: and trunc(pda.end_date) >= trunc(p_pa_date)
43: --trunc(p_ei_date) between trunc(pda.start_date) and trunc(pda.end_date)
44: -- R12 and nvl(pda.org_id,-99) = nvl(p_org_id,-99);

Line 132: from pa_periods_all ppd

128: and gps.adjustment_period_flag = 'N';
129: ELSIF p_time_phase_code = 'P' then
130: select ppd.end_date
131: into l_ed_date
132: from pa_periods_all ppd
133: where trunc(ppd.start_date) <= trunc(p_pa_date)
134: and trunc(ppd.end_date) >= trunc(p_pa_date)
135: --trunc(p_ei_date) between trunc(ppd.start_date) and trunc(ppd.end_date)
136: -- R12 and nvl(ppd.org_id,-99) = nvl(p_org_id,-99);