DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_END_DATES_V

Line 8605: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209

8601: FROM psp_enc_process_assignments pepa
8602: WHERE pepa.payroll_id = p_payroll_id
8603: AND pepa.assignment_status NOT IN ('B', 'P');
8604:
8605: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209
8606:
8607: BEGIN
8608: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ENC_PRE_PROCESS
8609: p_payroll_action_id: ' || p_payroll_action_id || '

Line 8671: from PSP_ENC_END_DATES_V

8667: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_inc_exc_flag: ' || l_inc_exc_flag);
8668:
8669: -- Bug 7188209
8670: select prev_enc_end_date into l_prev_enc_end_date
8671: from PSP_ENC_END_DATES_V
8672: where business_group_id = l_business_group_id
8673: and set_of_books_id = l_set_of_books_id;
8674: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_prev_enc_end_date = ' || l_prev_enc_end_date);
8675: