DBA Data[Home] [Help]

APPS.OPI_DBI_RES_PKG dependencies on GMP_RESOURCE_AVAIL

Line 1356: gmp_resource_avail ravail,

1352: FROM cr_rsrc_dtl rdtl,
1353: cr_rsrc_mst_b rmst,
1354: gmf_fiscal_policies pol,
1355: mtl_parameters mp,
1356: gmp_resource_avail ravail,
1357: org_organization_definitions org_def,
1358: cm_mthd_mst cmm
1359: WHERE rmst.resources = rdtl.resources
1360: AND rdtl.organization_id = org_def.organization_id

Line 1650: gmp_resource_avail ravail,

1646: SUM((ravail.to_time - ravail.from_time)*ravail.resource_units/3600) shift_hours
1647: FROM cr_rsrc_dtl rdtl,
1648: cr_rsrc_mst_b rmst,
1649: gmf_fiscal_policies pol,
1650: gmp_resource_avail ravail,
1651: mtl_parameters mp,
1652: org_organization_definitions org_def,
1653: cm_mthd_mst cmm
1654: WHERE rmst.resources = rdtl.resources