DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_ENC_END_DATES

Line 1765: FROM psp_enc_end_dates peed

1761:
1762: CURSOR default_end_date_cur (p_reference_id IN NUMBER) IS
1763: SELECT period_end_date,
1764: prev_enc_end_date
1765: FROM psp_enc_end_dates peed
1766: WHERE peed.enc_end_date_id = p_reference_id;
1767:
1768: CURSOR default_end_date_dec_cur IS
1769: SELECT DISTINCT

Line 1773: -- psp_enc_end_dates peed Commented for bug fix 4507892

1769: SELECT DISTINCT
1770: assignment_id,
1771: payroll_id
1772: FROM psp_enc_lines_history pelh
1773: -- psp_enc_end_dates peed Commented for bug fix 4507892
1774: WHERE pelh.change_flag = 'N'
1775: AND pelh.encumbrance_date > l_period_end_date;
1776: -- End of bug fix 3426871
1777:

Line 1790: -- psp_enc_end_dates peed Commented for bug fix 3426871

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
1793: AND pelh.change_flag = 'N'
1794: AND pelh.gl_code_combination_id IS NULL