APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_END_DATES_V

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

8925: FROM psp_enc_process_assignments pepa
8926: WHERE pepa.payroll_id = p_payroll_id
8927: AND pepa.assignment_status NOT IN ('B', 'P');
8928:
8929: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209
8930:
8931: -- Modifications for the delete statement for bug 9862281
8932: CURSOR exc_asg_cur(
8933: p_payroll_id NUMBER,

Line 9049: from PSP_ENC_END_DATES_V

9045:
9046: -- Bug 7188209
9047: -- Bug 10058104
9048: select prev_enc_end_date into l_prev_enc_end_date
9049: from PSP_ENC_END_DATES_V
9050: where business_group_id = l_business_group_id
9051: and set_of_books_id = l_set_of_books_id
9052: and default_org_flag='Y';
9053: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_prev_enc_end_date = ' || l_prev_enc_end_date);