APPS.PA_CUSTOMER_INFO dependencies on PA_PROJECT_CUSTOMERS

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

682: X_Inv_Exchange_Rate In Number,
683: X_Allow_Inv_Rate_Type_Fg In Varchar2,
684: X_Bill_Another_Project_Fg In Varchar2,
685: X_Receiver_Task_Id In Number,
686: P_default_top_task_customer In pa_project_customers.DEFAULT_TOP_TASK_CUST_FLAG%TYPE default 'N',
687: X_User In Number,
688: X_Login In Number,
689: X_Err_Code In Out NOCOPY Number, --File.Sql.39 bug 4440895
690: X_Err_Stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 696: c_customer_id pa_project_customers.customer_id%TYPE)

692:
693: l_dummy VARCHAR2(1); -- Added for Bug 3110489
694: /** Cursor added for Bug 3110489 **/
695: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
696: c_customer_id pa_project_customers.customer_id%TYPE)
697: IS
698: Select 'Y' FROM pa_project_customers
699: WHERE project_id = c_project_id
700: AND customer_id = c_customer_id;

Line 698: Select 'Y' FROM pa_project_customers

694: /** Cursor added for Bug 3110489 **/
695: CURSOR Cur_Customer_Exists(c_project_id pa_projects_all.project_id%TYPE,
696: c_customer_id pa_project_customers.customer_id%TYPE)
697: IS
698: Select 'Y' FROM pa_project_customers
699: WHERE project_id = c_project_id
700: AND customer_id = c_customer_id;
701:
702: --bug 4054587

Line 719: Insert Into Pa_Project_Customers

715: FETCH Cur_Customer_Exists INTO l_dummy;
716: IF Cur_Customer_Exists%NOTFOUND then
717: /** Code change ends for Bug 3110489 **/
718:
719: Insert Into Pa_Project_Customers
720: ( Project_Id,
721: Customer_Id,
722: Project_Relationship_Code,
723: Customer_Bill_Split,

Line 1130: FROM pa_project_customers pc

1126: where project_id = p_project_Id;
1127:
1128: CURSOR C IS
1129: SELECT sum(pc.customer_bill_split)
1130: FROM pa_project_customers pc
1131: WHERE pc.project_id = p_project_Id
1132: GROUP by pc.project_id;
1133:
1134: