APPS.PA_EXP_COPY dependencies on PA_TASKS

Line 153: pa_tasks t

149: , i.projfunc_cost_exchange_rate
150: , com.expenditure_comment --bug 3066137
151: , i.cbs_element_id -- Added for Bug 16387823
152: FROM
153: pa_tasks t
154: , pa_expenditure_items i
155: , pa_expenditure_comments com --bug 3066137
156: WHERE
157: ( X_exp_class_code = 'OE'

Line 943: l_project_id pa_tasks.project_id%TYPE;

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

Line 1000: FROM pa_tasks

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