APPS.PA_EXP_COPY dependencies on PA_TASKS

Line 152: pa_tasks t

148: , i.projfunc_cost_rate_date
149: , i.projfunc_cost_exchange_rate
150: , com.expenditure_comment --bug 3066137
151: FROM
152: pa_tasks t
153: , pa_expenditure_items i
154: , pa_expenditure_comments com --bug 3066137
155: WHERE
156: ( X_exp_class_code = 'OE'

Line 940: l_project_id pa_tasks.project_id%TYPE;

936: ExpEi RevExpItems%rowtype ;
937: ExpGroup ReverseGroup%rowtype ;
938: outcome VARCHAR2(100);
939: Dummy NUMBER;
940: l_project_id pa_tasks.project_id%TYPE;
941: l_org_id NUMBER := pa_moac_utils.get_current_org_id;
942:
943: BEGIN
944: /*

Line 997: FROM pa_tasks

993: EXIT WHEN RevExpItems%NOTFOUND;
994:
995: SELECT project_id
996: INTO l_project_id
997: FROM pa_tasks
998: WHERE task_id = ExpEi.task_id;
999:
1000: /* OTL item is checked in OTL to see if change has been made in OTL. */
1001: If ExpEi.transaction_source = 'ORACLE TIME AND LABOR' and