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 757: (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*/

753: G_creation_date,
754: decode(p_internal_billing_type, 'PA_IC_INVOICES', p_project_id(i), p_receiver_project_id),
755: decode(p_internal_billing_type,'PA_IC_INVOICES',p_task_id(i), p_receiver_task_id),
756: p_expenditure_type(i),
757: (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*/
758: p_expenditure_organization_id(i),
759: 'Yes',
760: decode(p_internal_billing_type,'PA_IC_INVOICES','T','N'),/*Bug# 2042840*/
761: p_pa_quantity(i),