DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PJI_TIME_CAL_PERIOD_V

Line 12574: PJI_TIME_CAL_PERIOD_V ptcpv,

12570: ptcpv.name period_name,
12571: ptcpv.start_date pstart_date,
12572: ptcpv.end_date pend_date
12573: from
12574: PJI_TIME_CAL_PERIOD_V ptcpv,
12575: (
12576: select ppv.proj_element_id proj_element_id,
12577: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12578: from pa_progress_rollup ppr,

Line 12627: PJI_TIME_CAL_PERIOD_V ptcpv,

12623: ptcpv.name period_name,
12624: ptcpv.start_date pstart_date,
12625: ptcpv.end_date pend_date
12626: from
12627: PJI_TIME_CAL_PERIOD_V ptcpv,
12628: (
12629: select ppv.proj_element_id proj_element_id,
12630: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12631: from pa_progress_rollup ppr,

Line 12681: PJI_TIME_CAL_PERIOD_V ptcpv,

12677: ptcpv.name period_name,
12678: ptcpv.start_date pstart_date,
12679: ptcpv.end_date pend_date
12680: from
12681: PJI_TIME_CAL_PERIOD_V ptcpv,
12682: (
12683: select ppv.proj_element_id proj_element_id,
12684: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12685: from pa_progress_rollup ppr,

Line 12735: PJI_TIME_CAL_PERIOD_V ptcpv,

12731: ptcpv.name period_name,
12732: ptcpv.start_date pstart_date,
12733: ptcpv.end_date pend_date
12734: from
12735: PJI_TIME_CAL_PERIOD_V ptcpv,
12736: (
12737: select ppv.proj_element_id proj_element_id,
12738: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12739: from pa_progress_rollup ppr,

Line 12791: PJI_TIME_CAL_PERIOD_V ptcpv,

12787: ptcpv.name period_name,
12788: ptcpv.start_date pstart_date,
12789: ptcpv.end_date pend_date
12790: from
12791: PJI_TIME_CAL_PERIOD_V ptcpv,
12792: (
12793: select ppv.proj_element_id proj_element_id,
12794: max(ppv.parent_structure_version_id) parent_structure_id,
12795: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date

Line 12846: PJI_TIME_CAL_PERIOD_V ptcpv,

12842: ptcpv.name period_name,
12843: ptcpv.start_date pstart_date,
12844: ptcpv.end_date pend_date
12845: from
12846: PJI_TIME_CAL_PERIOD_V ptcpv,
12847: (
12848: select ppv.proj_element_id proj_element_id,
12849: max(ppv.parent_structure_version_id) parent_structure_id,
12850: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date