DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on PJI_TIME_ENT_PERIOD_V

Line 1235: PJI_TIME_ENT_PERIOD_V ent,

1231: pa_per.ORG_ID = tmp2.PROJECT_ORG_ID and
1232: to_date(to_char(tmp2.RECVR_PA_TIME_ID), 'J')
1233: between pa_per.START_DATE and pa_per.END_DATE
1234: ) tmp2,
1235: PJI_TIME_ENT_PERIOD_V ent,
1236: (
1237: select
1238: distinct
1239: usg.PERSON_ID,

Line 2258: PJI_TIME_ENT_PERIOD_V ent

2254: pa_per.ORG_ID = tmp2.PROJECT_ORG_ID and
2255: to_date(to_char(tmp2.PA_TIME_ID), 'J') between pa_per.START_DATE
2256: and pa_per.END_DATE
2257: ) tmp2,
2258: PJI_TIME_ENT_PERIOD_V ent
2259: where
2260: tmp2.WORKER_ID = p_worker_id and
2261: to_date(to_char(tmp2.GL_TIME_ID), 'J') between ent.START_DATE and
2262: ent.END_DATE