APPS.PJI_FM_PLAN_EXTR dependencies on PJI_ORG_EXTR_INFO

Line 239: Update PJI_ORG_EXTR_INFO orginfo

235: end if;
236:
237: get_system_settings;
238:
239: Update PJI_ORG_EXTR_INFO orginfo
240: set
241: ( orginfo.PA_FIRST_PERIOD_ID
242: , orginfo.PA_FIRST_PERIOD_NAME
243: , orginfo.PA_FIRST_START_DATE

Line 266: Update PJI_ORG_EXTR_INFO orginfo

262: )
263: ;
264:
265:
266: Update PJI_ORG_EXTR_INFO orginfo
267: set
268: ( orginfo.GL_FIRST_PERIOD_ID
269: , orginfo.GL_FIRST_PERIOD_NAME
270: , orginfo.GL_FIRST_START_DATE

Line 627: PJI_ORG_EXTR_INFO orginfo

623: , null) time_dangling_flag
624: , null rate_dangling_flag
625: , null rate2_dangling_flag
626: from
627: PJI_ORG_EXTR_INFO orginfo
628: , PJI_FM_EXTR_PLNVER1 vers
629: , pa_resource_assignments ra
630: , pa_budget_lines bl
631: , ( select -1 calendar_id

Line 818: PJI_ORG_EXTR_INFO orginfo

814: ) time_dangling_flag
815: , tmp.rate_dangling_flag rate_dangling_flag
816: , tmp.rate2_dangling_flag rate2_dangling_flag
817: from
818: PJI_ORG_EXTR_INFO orginfo
819: , PJI_FM_EXTR_PLAN tmp
820: , fii_time_ent_period ent
821: where tmp.worker_id = p_worker_id
822: and tmp.end_date >= ent.start_date

Line 1355: PJI_ORG_EXTR_INFO orginfo

1351: ) time_dangling_flag
1352: , tmp.rate_dangling_flag rate_dangling_flag
1353: , tmp.rate2_dangling_flag rate2_dangling_flag
1354: from
1355: PJI_ORG_EXTR_INFO orginfo
1356: , PJI_FM_EXTR_PLAN tmp
1357: , fii_time_cal_period cal_pa
1358: where tmp.worker_id = p_worker_id
1359: and tmp.end_date >= cal_pa.start_date

Line 1527: PJI_ORG_EXTR_INFO orginfo

1523: ) time_dangling_flag
1524: , tmp.rate_dangling_flag rate_dangling_flag
1525: , tmp.rate2_dangling_flag rate2_dangling_flag
1526: from
1527: PJI_ORG_EXTR_INFO orginfo
1528: , PJI_FM_EXTR_PLAN tmp
1529: , fii_time_cal_period cal_gl
1530: where tmp.worker_id = p_worker_id
1531: and tmp.end_date >= cal_gl.start_date

Line 1695: PJI_ORG_EXTR_INFO orginfo

1691: ) time_dangling_flag
1692: , tmp.rate_dangling_flag rate_dangling_flag
1693: , tmp.rate2_dangling_flag rate2_dangling_flag
1694: from
1695: PJI_ORG_EXTR_INFO orginfo
1696: , PJI_FM_EXTR_PLAN tmp
1697: , fii_time_ent_period ent
1698: where tmp.worker_id = p_worker_id
1699: and tmp.end_date >= ent.start_date

Line 1860: PJI_ORG_EXTR_INFO orginfo

1856: ) time_dangling_flag
1857: , tmp.rate_dangling_flag rate_dangling_flag
1858: , tmp.rate2_dangling_flag rate2_dangling_flag
1859: from
1860: PJI_ORG_EXTR_INFO orginfo
1861: , PJI_FM_EXTR_PLAN tmp
1862: , fii_time_week entw
1863: where tmp.worker_id = p_worker_id
1864: and tmp.end_date >= entw.start_date

Line 1936: from PJI_ORG_EXTR_INFO orginfo

1932: , decode(tmp.CALENDAR_TYPE_CODE
1933: , 'PA', orginfo.PA_CALENDAR_ID
1934: , 'GL', orginfo.GL_CALENDAR_ID
1935: , null) CALENDAR_ID
1936: from PJI_ORG_EXTR_INFO orginfo
1937: , PJI_FM_EXTR_PLAN tmp
1938: where tmp.WORKER_ID = p_worker_id
1939: and ( tmp.TIME_DANGLING_FLAG is not null
1940: or tmp.RATE_DANGLING_FLAG is not null