APPS.PA_CC_AR_AP_TRANSFER dependencies on PA_TASKS

Line 117: pa_tasks pt

113: Cursor c_receiver_project_task (p_project_customer_id in number,p_project_id in number) is
114: select ppc.receiver_task_id task_id,
115: pt.project_id project_id
116: from pa_project_customers ppc,
117: pa_tasks pt
118: where pt.task_id=ppc.receiver_task_id
119: and ppc.customer_id=p_project_customer_id
120: and ppc.project_id=p_project_id;
121:

Line 761: (select least(NVL(completion_date,p_invoice_date),p_invoice_date) from pa_tasks pt where pt.task_id =decode(p_internal_billing_type,'PA_IC_INVOICES',p_task_id(i), p_receiver_task_id)), /* Modified this for bug 7234925*/

757: G_creation_date,
758: decode(p_internal_billing_type, 'PA_IC_INVOICES', p_project_id(i), p_receiver_project_id),
759: decode(p_internal_billing_type,'PA_IC_INVOICES',p_task_id(i), p_receiver_task_id),
760: p_expenditure_type(i),
761: (select least(NVL(completion_date,p_invoice_date),p_invoice_date) from pa_tasks pt where pt.task_id =decode(p_internal_billing_type,'PA_IC_INVOICES',p_task_id(i), p_receiver_task_id)), /* Modified this for bug 7234925*/
762: p_expenditure_organization_id(i),
763: 'Yes',
764: decode(p_internal_billing_type,'PA_IC_INVOICES','T','N'),/*Bug# 2042840*/
765: p_pa_quantity(i),