APPS.OPI_DBI_RES_PKG dependencies on GMF_PERIOD_STATUSES

Line 1388: FROM gmf_period_statuses period

1384: period.legal_entity_id,
1385: period.period_id,
1386: period.start_date,
1387: period.end_date
1388: FROM gmf_period_statuses period
1389: WHERE period.end_date >= p_start_date
1390: AND period.start_date <= p_end_date
1391: ) cal,
1392: sy_uoms_mst_v ruom,

Line 1683: FROM gmf_period_statuses period

1679: period.legal_entity_id,
1680: period.period_id,
1681: period.start_date,
1682: period.end_date
1683: FROM gmf_period_statuses period
1684: WHERE period.end_date >= l_start_date
1685: AND period.start_date <= l_end_date
1686: ) cal,
1687: sy_uoms_mst_v ruom,

Line 1885: FROM gmf_period_statuses period

1881: period.legal_entity_id,
1882: period.period_id,
1883: period.start_date,
1884: period.end_date
1885: FROM gmf_period_statuses period
1886: WHERE period.end_date >= g_global_start_date
1887: AND period.start_date <= sysdate
1888: ) cal,
1889: cm_rsrc_dtl rescost,

Line 2110: FROM gmf_period_statuses period

2106: period.legal_entity_id,
2107: period.period_id,
2108: period.start_date,
2109: period.end_date
2110: FROM gmf_period_statuses period
2111: WHERE period.end_date >= g_global_start_date
2112: AND period.start_date <= sysdate
2113: ) cal,
2114: cm_rsrc_dtl rescost,