DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on PA_LIFECYCLE_USAGES

Line 1449: ,pa_lifecycle_usages plu

1445: p_lifecycle_id NUMBER
1446: ) IS
1447: SELECT pev_p.proj_element_id
1448: FROM pa_proj_element_versions pev_l
1449: ,pa_lifecycle_usages plu
1450: ,pa_proj_element_versions pev_p
1451: ,pa_proj_elements ppe_p
1452: ,pa_project_statuses pc
1453: WHERE pev_l.object_type = 'PA_STRUCTURES'

Line 1586: PA_LIFECYCLE_USAGES plu,

1582:
1583: /* CURSOR c_get_default_phase_id (cp_lifecycle_id IN NUMBER) IS
1584: SELECT pev_p.PROJ_ELEMENT_ID
1585: FROM PA_PROJ_ELEMENT_VERSIONS pev_l,
1586: PA_LIFECYCLE_USAGES plu,
1587: PA_PROJ_ELEMENT_VERSIONS pev_p,
1588: PA_PROJ_ELEMENTS PPE_P,
1589: PA_PROJECT_STATUSES pc
1590: WHERE pev_l.OBJECT_TYPE = 'PA_STRUCTURES'