APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECT_CUSTOMERS

Line 695: P_default_top_task_customer In pa_project_customers.DEFAULT_TOP_TASK_CUST_FLAG%TYPE default 'N',

691: X_Inv_Exchange_Rate In Number,
692: X_Allow_Inv_Rate_Type_Fg In Varchar2,
693: X_Bill_Another_Project_Fg In Varchar2,
694: X_Receiver_Task_Id In Number,
695: P_default_top_task_customer In pa_project_customers.DEFAULT_TOP_TASK_CUST_FLAG%TYPE default 'N',
696: X_User In Number,
697: X_Login In Number,
698: X_Err_Code In Out NOCOPY Number, --File.Sql.39 bug 4440895
699: X_Err_Stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 705: c_customer_id pa_project_customers.customer_id%TYPE)

701:
702: l_dummy VARCHAR2(1); -- Added for Bug 3110489
703: /** Cursor added for Bug 3110489 **/
704: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
705: c_customer_id pa_project_customers.customer_id%TYPE)
706: IS
707: Select 'Y' FROM pa_project_customers
708: WHERE project_id = c_project_id
709: AND customer_id = c_customer_id;

Line 707: Select 'Y' FROM pa_project_customers

703: /** Cursor added for Bug 3110489 **/
704: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
705: c_customer_id pa_project_customers.customer_id%TYPE)
706: IS
707: Select 'Y' FROM pa_project_customers
708: WHERE project_id = c_project_id
709: AND customer_id = c_customer_id;
710:
711: --bug 4054587

Line 728: Insert Into Pa_Project_Customers

724: FETCH Cur_Customer_Exists INTO l_dummy;
725: IF Cur_Customer_Exists%NOTFOUND then
726: /** Code change ends for Bug 3110489 **/
727:
728: Insert Into Pa_Project_Customers
729: ( Project_Id,
730: Customer_Id,
731: Project_Relationship_Code,
732: Customer_Bill_Split,

Line 1139: FROM pa_project_customers pc

1135: where project_id = p_project_Id;
1136:
1137: CURSOR C IS
1138: SELECT sum(pc.customer_bill_split)
1139: FROM pa_project_customers pc
1140: WHERE pc.project_id = p_project_Id
1141: GROUP by pc.project_id;
1142:
1143: