DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PJI_TIME_CAL_PERIOD_V

Line 12668: PJI_TIME_CAL_PERIOD_V ptcpv,

12664: ptcpv.name period_name,
12665: ptcpv.start_date pstart_date,
12666: ptcpv.end_date pend_date
12667: from
12668: PJI_TIME_CAL_PERIOD_V ptcpv,
12669: (
12670: select ppv.proj_element_id proj_element_id,
12671: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12672: from pa_progress_rollup ppr,

Line 12721: PJI_TIME_CAL_PERIOD_V ptcpv,

12717: ptcpv.name period_name,
12718: ptcpv.start_date pstart_date,
12719: ptcpv.end_date pend_date
12720: from
12721: PJI_TIME_CAL_PERIOD_V ptcpv,
12722: (
12723: select ppv.proj_element_id proj_element_id,
12724: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12725: from pa_progress_rollup ppr,

Line 12775: PJI_TIME_CAL_PERIOD_V ptcpv,

12771: ptcpv.name period_name,
12772: ptcpv.start_date pstart_date,
12773: ptcpv.end_date pend_date
12774: from
12775: PJI_TIME_CAL_PERIOD_V ptcpv,
12776: (
12777: select ppv.proj_element_id proj_element_id,
12778: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12779: from pa_progress_rollup ppr,

Line 12829: PJI_TIME_CAL_PERIOD_V ptcpv,

12825: ptcpv.name period_name,
12826: ptcpv.start_date pstart_date,
12827: ptcpv.end_date pend_date
12828: from
12829: PJI_TIME_CAL_PERIOD_V ptcpv,
12830: (
12831: select ppv.proj_element_id proj_element_id,
12832: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12833: from pa_progress_rollup ppr,

Line 12885: PJI_TIME_CAL_PERIOD_V ptcpv,

12881: ptcpv.name period_name,
12882: ptcpv.start_date pstart_date,
12883: ptcpv.end_date pend_date
12884: from
12885: PJI_TIME_CAL_PERIOD_V ptcpv,
12886: (
12887: select ppv.proj_element_id proj_element_id,
12888: max(ppv.parent_structure_version_id) parent_structure_id,
12889: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date

Line 12940: PJI_TIME_CAL_PERIOD_V ptcpv,

12936: ptcpv.name period_name,
12937: ptcpv.start_date pstart_date,
12938: ptcpv.end_date pend_date
12939: from
12940: PJI_TIME_CAL_PERIOD_V ptcpv,
12941: (
12942: select ppv.proj_element_id proj_element_id,
12943: max(ppv.parent_structure_version_id) parent_structure_id,
12944: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date