APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_SCHEDULE_LINES

Line 473: dates psp_schedule_lines for poeta CI. It inserts assignments in

469:
470: /****************************************************************************************************
471: Procedure Name: UPDATE_SCHEDULES
472: Purpose: This procedure is called in the main procedure and used for updating poeta
473: dates psp_schedule_lines for poeta CI. It inserts assignments in
474: psp_enc_changed_assignments if the poeta dates are different from previous
475: poeta dates and assignments exist in psp_enc_lines_history table.
476: ****************************************************************************************************/
477:

Line 531: psp_schedule_lines psl ,

527: psl.schedule_end_date,
528: NVL(psl.poeta_start_date,TO_DATE('01-01-1800', 'DD-MM-YYYY')) poeta_start_date,
529: NVL(psl.poeta_end_date,TO_DATE('31-12-4712', 'DD-MM-YYYY')) poeta_start_date
530: FROM psp_schedule_hierarchy psh,
531: psp_schedule_lines psl ,
532: per_assignments_f paf
533: WHERE psl.business_group_id = p_business_group_id
534: AND psl.set_of_books_id = p_set_of_books_id
535: AND psl.schedule_hierarchy_id = psh.schedule_hierarchy_id

Line 687: /* Updating poeta dates in psp_schedule_lines */

683: -- Introduced for bug fix 3434626
684: l_proc_step := 70;
685: -- End of bug fix 3434626
686:
687: /* Updating poeta dates in psp_schedule_lines */
688: FORALL i in 1 .. g_total_num_rec
689: UPDATE psp_schedule_lines
690: SET poeta_end_date = r_schedule_control_rec.r_poeta_end_date(i),
691: poeta_start_date = r_schedule_control_rec.r_poeta_start_date(i)

Line 689: UPDATE psp_schedule_lines

685: -- End of bug fix 3434626
686:
687: /* Updating poeta dates in psp_schedule_lines */
688: FORALL i in 1 .. g_total_num_rec
689: UPDATE psp_schedule_lines
690: SET poeta_end_date = r_schedule_control_rec.r_poeta_end_date(i),
691: poeta_start_date = r_schedule_control_rec.r_poeta_start_date(i)
692: WHERE schedule_line_id = r_schedule_control_rec.r_schedule_line_id(i);
693:

Line 1787: psp_schedule_lines psl,

1783: pelh.assignment_id,
1784: pelh.payroll_id
1785: FROM psp_enc_lines_history pelh,
1786: psp_default_labor_schedules pdls,
1787: psp_schedule_lines psl,
1788: psp_element_type_accounts peta,
1789: per_assignments_f paf
1790: -- psp_enc_end_dates peed Commented for bug fix 3426871
1791: --WHERE peed.enc_end_date_id = p_reference_id Commented for bug fix 3426871