DBA Data[Home] [Help]

APPS.PSP_ORG_DLS_PKG dependencies on PSP_ELEMENT_GROUPS

Line 485: PSP_ELEMENT_GROUPS PEG

481: and c.SCHEDULING_TYPES_CODE = ''EG''
482: and f.ELEMENT_GROUP_ID IN (Select Distinct
483: PGEL.ELEMENT_GROUP_ID
484: from PSP_GROUP_ELEMENT_LIST PGEL,
485: PSP_ELEMENT_GROUPS PEG
486: where PGEL.Element_Type_ID IN ' ||
487: g_element_type_id_str || '
488: and PGEL.Element_Group_ID =
489: PEG.Element_Group_ID)

Line 1333: PSP_ELEMENT_GROUPS PEG

1329: and c.SCHEDULING_TYPES_CODE = 'EG'
1330: and e.element_group_id = c.ELEMENT_GROUP_ID
1331: and e.ELEMENT_GROUP_ID = (Select Distinct PGEL.ELEMENT_GROUP_ID
1332: from PSP_GROUP_ELEMENT_LIST PGEL,
1333: PSP_ELEMENT_GROUPS PEG
1334: where PGEL.Element_Type_ID = l_Element_Type_ID
1335: and PGEL.Element_Group_ID = PEG.Element_Group_ID
1336: and (PEG.Start_Date_Active Between
1337: l_Time_Period_Start and