DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on PJI_TIME_ENT_PERIOD_V

Line 1255: PJI_TIME_ENT_PERIOD_V ent,

1251: pa_per.ORG_ID = tmp2.PROJECT_ORG_ID and
1252: to_date(to_char(tmp2.RECVR_PA_TIME_ID), 'J')
1253: between pa_per.START_DATE and pa_per.END_DATE
1254: ) tmp2,
1255: PJI_TIME_ENT_PERIOD_V ent,
1256: (
1257: select
1258: distinct
1259: usg.PERSON_ID,

Line 2280: PJI_TIME_ENT_PERIOD_V ent

2276: pa_per.ORG_ID = tmp2.PROJECT_ORG_ID and
2277: to_date(to_char(tmp2.PA_TIME_ID), 'J') between pa_per.START_DATE
2278: and pa_per.END_DATE
2279: ) tmp2,
2280: PJI_TIME_ENT_PERIOD_V ent
2281: where
2282: tmp2.WORKER_ID = p_worker_id and
2283: to_date(to_char(tmp2.GL_TIME_ID), 'J') between ent.START_DATE and
2284: ent.END_DATE