APPS.PSP_ORG_DLS_PKG dependencies on PSP_GROUP_ELEMENT_LIST

Line 469: PSP_GROUP_ELEMENT_LIST f,

465: from PER_ASSIGNMENTS_F a,
466: PSP_SCHEDULES b,
467: PSP_SCHEDULE_HIERARCHY c,
468: PSP_SCHEDULE_LINES d,
469: PSP_GROUP_ELEMENT_LIST f,
470: PSP_DEFAULT_LABOR_SCHEDULES g
471: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
472: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID
473: and c.SCHEDULE_HIERARCHY_ID = d.SCHEDULE_HIERARCHY_ID

Line 484: from PSP_GROUP_ELEMENT_LIST PGEL,

480: a.EFFECTIVE_END_DATE)
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 =

Line 1180: PSP_GROUP_ELEMENT_LIST e

1176: from PER_ASSIGNMENTS_F a,
1177: PSP_SCHEDULES b,
1178: PSP_SCHEDULE_HIERARCHY c,
1179: PSP_SCHEDULE_LINES d,
1180: PSP_GROUP_ELEMENT_LIST e
1181: where a.assignment_id = b.assignment_id
1182: and b.assignment_id = c.assignment_id
1183: and c.schedule_hierarchy_id = d.schedule_hierarchy_id
1184: and a.assignment_id = l_Assignment_ID

Line 1321: PSP_GROUP_ELEMENT_LIST e

1317: from PER_ASSIGNMENTS_F a,
1318: PSP_SCHEDULES b,
1319: PSP_SCHEDULE_HIERARCHY c,
1320: PSP_SCHEDULE_LINES d,
1321: PSP_GROUP_ELEMENT_LIST e
1322: where a.assignment_id = b.assignment_id
1323: and b.assignment_id = c.assignment_id
1324: and c.schedule_hierarchy_id = d.schedule_hierarchy_id
1325: and a.assignment_id = l_Assignment_ID

Line 1332: from PSP_GROUP_ELEMENT_LIST PGEL,

1328: or d.schedule_end_date >= l_Time_Period_End)
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