APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_END_DATES

Line 649: FROM psp_enc_end_dates peed

645: IS
646: SELECT peed.period_end_date,
647: peed.enc_end_date_id,
648: NVL(peed.prev_enc_end_date, fnd_date.canonical_to_date('4712/12/31')) prev_enc_end_date
649: FROM psp_enc_end_dates peed
650: WHERE
651: --- removed sysdate check for Bug fix 2597666
652: peed.business_group_id = p_business_group_id
653: AND peed.set_of_books_id = p_set_of_books_id

Line 664: FROM psp_enc_end_dates peed

660:
661: CURSOR c_cnt_default_org
662: IS
663: SELECT COUNT(1)
664: FROM psp_enc_end_dates peed
665: WHERE
666: -- removed sysdate check for Bug Fix 2597666
667: peed.business_group_id = p_business_group_id
668: AND peed.set_of_books_id = p_set_of_books_id

Line 702: UPDATE psp_enc_end_dates peed

698: CLOSE time_pct_def_cur;
699:
700: --For Enhancement Enc Redesign:Bug 2259310 : Updating the Organization End date
701: IF (l_prev_enc_end_date <> p_enc_org_end_date) THEN
702: UPDATE psp_enc_end_dates peed
703: SET peed.prev_enc_end_date = p_enc_org_end_date
704: WHERE peed.enc_end_date_id = l_enc_end_date_id;
705: END IF;
706: Exception

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);