APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_ELEMENT_TYPE_ACCOUNTS

Line 251: dates in psp_element_type_accounts for poeta CI It inserts assignments in

247:
248: /****************************************************************************************************
249: Procedure Name: UPDATE_GLOBAL_EARNING_ELEMENTS
250: Purpose: This procedure is called in the main procedure and used for updating poeta
251: dates in psp_element_type_accounts for poeta CI It inserts assignments in
252: psp_enc_changed_assignments if the poeta dates are different from previous
253: poeta dates and assignments exists in psp_enc_lines_history table.
254: ****************************************************************************************************/
255:

Line 301: FROM psp_element_type_accounts peta

297: peta.start_date_active,
298: peta.end_date_active,
299: NVL(peta.poeta_start_date, TO_DATE('01-01-1800', 'DD-MM-YYYY')) poeta_start_date,
300: NVL(peta.poeta_end_date,TO_DATE('31-12-4712', 'DD-MM-YYYY')) poeta_end_date
301: FROM psp_element_type_accounts peta
302: WHERE peta.gl_code_combination_id is NULL
303: AND peta.end_date_active >= p_max_pay_date
304: AND peta.business_group_id = p_business_group_id
305: AND peta.set_of_books_id = p_set_of_books_id

Line 447: /* Updating poeta dates in psp_element_type_accounts */

443: END LOOP;
444:
445: l_proc_step := 60; -- Introduced for bug fix 3434626
446:
447: /* Updating poeta dates in psp_element_type_accounts */
448: FORALL i in 1 .. g_total_num_rec
449: UPDATE psp_element_type_accounts
450: SET poeta_start_date = r_global_control_rec.r_poeta_start_date(i),
451: poeta_end_date = r_global_control_rec.r_poeta_end_date(i)

Line 449: UPDATE psp_element_type_accounts

445: l_proc_step := 60; -- Introduced for bug fix 3434626
446:
447: /* Updating poeta dates in psp_element_type_accounts */
448: FORALL i in 1 .. g_total_num_rec
449: UPDATE psp_element_type_accounts
450: SET poeta_start_date = r_global_control_rec.r_poeta_start_date(i),
451: poeta_end_date = r_global_control_rec.r_poeta_end_date(i)
452: WHERE element_account_id = r_global_control_rec.r_global_line_id(i);
453:

Line 1788: psp_element_type_accounts peta,

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
1792: WHERE pelh.assignment_id = paf.assignment_id