APPS.PSP_ENC_SUM_TRAN dependencies on PA_TASKS_EXPEND_V

Line 4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)

4619: papf.employee_number --Added for Bug 10126350
4620: FROM psp_enc_summary_lines pesl,
4621: hr_organization_units hou,
4622: pa_projects_all ppa,
4623: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
4624: per_time_periods ptp,
4625: psp_enc_controls pec
4626: ,per_all_people_f papf --Added for Bug 10126350
4627: WHERE pec.payroll_action_id = p_payroll_action_id

Line 6077: FROM pa_tasks_expend_v -- Bug : 16391366 (20/03/2013)

6073: WHERE award_id = l_award_id;
6074:
6075: CURSOR task_number_cur Is
6076: SELECT task_number
6077: FROM pa_tasks_expend_v -- Bug : 16391366 (20/03/2013)
6078: WHERE task_id = l_task_id;
6079:
6080: CURSOR exp_org_name_cur IS
6081: SELECT name

Line 7140: FROM pa_tasks_expend_v -- Bug 16391366

7136: WHERE award_id = p_award_id;
7137:
7138: CURSOR task_number_cur (p_task_id IN NUMBER) IS
7139: SELECT task_number
7140: FROM pa_tasks_expend_v -- Bug 16391366
7141: WHERE task_id = p_task_id;
7142:
7143: CURSOR exp_org_name_cur (p_expenditure_org_id IN NUMBER) IS
7144: SELECT name