APPS.PSP_ORG_DLS_PKG dependencies on PSP_DEFAULT_LABOR_SCHEDULES

Line 286: PSP_DEFAULT_LABOR_SCHEDULES f

282: from PER_ASSIGNMENTS_F a,
283: PSP_SCHEDULES b,
284: PSP_SCHEDULE_HIERARCHY c,
285: PSP_SCHEDULE_LINES d,
286: PSP_DEFAULT_LABOR_SCHEDULES f
287: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
288: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID
289: and c.SCHEDULE_HIERARCHY_ID = d.SCHEDULE_HIERARCHY_ID
290: and NOT(d.SCHEDULE_BEGIN_DATE <= :p_start_date AND

Line 470: PSP_DEFAULT_LABOR_SCHEDULES g

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
474: and f.ELEMENT_GROUP_ID = c.ELEMENT_GROUP_ID

Line 738: PSP_DEFAULT_LABOR_SCHEDULES f

734: from PER_ASSIGNMENTS_F a,
735: PSP_SCHEDULES b,
736: PSP_SCHEDULE_HIERARCHY c,
737: PSP_SCHEDULE_LINES d,
738: PSP_DEFAULT_LABOR_SCHEDULES f
739: where a.ASSIGNMENT_ID = b.ASSIGNMENT_ID
740: and b.ASSIGNMENT_ID = c.ASSIGNMENT_ID
741: and c.SCHEDULE_HIERARCHY_ID = d.SCHEDULE_HIERARCHY_ID
742: and NOT(d.SCHEDULE_BEGIN_DATE <= :p_start_date AND

Line 1606: numbers to the PSP_REP_ORG_DLS table. Instead, the Org_Schedule_ID from PSP_DEFAULT_LABOR_SCHEDULES

1602: return;
1603: end;
1604: /********************************************************************************************************
1605: Though this procedure accepts Schedule Line Numbers, this is no longer adding these line
1606: numbers to the PSP_REP_ORG_DLS table. Instead, the Org_Schedule_ID from PSP_DEFAULT_LABOR_SCHEDULES
1607: is being added. The report will have to obtain the Default Labor Schedule Charging Instruction from
1608: this.
1609: *********************************************************************************************************/
1610: PROCEDURE Add_If_Within_DLS(v_Organization_ID Number, v_Begin_Date DATE,

Line 1615: from PSP_DEFAULT_LABOR_SCHEDULES

1611: v_End_Date DATE, v_Assignment_ID Number, v_Person_ID Number, v_Element_Type_ID Number,
1612: v_Original_Sch_Code varchar2, v_Schedule_Line_ID Number) IS
1613: Cursor C1 is
1614: Select Org_Schedule_ID, Schedule_Begin_Date, Schedule_End_Date
1615: from PSP_DEFAULT_LABOR_SCHEDULES
1616: where Organization_ID = v_Organization_ID;
1617: DLS_Begin_Date DATE;
1618: DLS_End_Date DATE;
1619: Begin