[Home] [Help]
759: l_prev_exp_organization_id NUMBER(15) DEFAULT -1;
760: l_prev_expenditure_type VARCHAR2(30) DEFAULT '-1';
761: l_prev_tx_project_id NUMBER(15) DEFAULT -1;
762:
763: /* Cursor will select distinct poeta combinations from psp_default_labor_schedules for a payroll. */
764: CURSOR org_labor_schedule_cur IS
765: SELECT pdls.org_schedule_id,
766: pdls.project_id,
767: pdls.task_id,
771: pdls.schedule_begin_date,
772: pdls.schedule_end_date,
773: NVL(pdls.poeta_start_date,TO_DATE('01-01-1800', 'DD-MM-YYYY')) poeta_start_date,
774: NVL(pdls.poeta_end_date,TO_DATE('31-12-4712', 'DD-MM-YYYY')) poeta_end_date
775: FROM psp_default_labor_schedules pdls
776: WHERE pdls.business_group_id = p_business_group_id
777: AND pdls.set_of_books_id = p_set_of_books_id
778: AND pdls.gl_code_combination_id IS NULL
779: AND pdls.schedule_end_date >= p_max_pay_date
927: -- End of bug fix 3434626
928:
929: /*Updating poeta dates in psp_default_labor_schedule table */
930: FORALL i in 1 .. g_total_num_rec
931: UPDATE psp_default_labor_schedules
932: SET poeta_end_date = r_ls_control_rec.r_poeta_end_date(i),
933: poeta_start_date = r_ls_control_rec.r_poeta_start_date(i)
934: WHERE org_schedule_id = r_ls_control_rec.r_org_schedule_id(i);
935:
1782: SELECT DISTINCT --Added distinct for bug 2664991.
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