APPS.PA_TOP_TASK_CUST_INVOICE_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 129: UPDATE pa_project_customers SET default_top_task_cust_flag = 'N'

125:
126: UPDATE pa_tasks SET customer_id = null
127: WHERE project_id = p_project_id;
128:
129: UPDATE pa_project_customers SET default_top_task_cust_flag = 'N'
130: WHERE customer_id = p_def_top_task_cust AND project_id = p_project_id;
131:
132: --sunkalya:federal Bug#5511353
133: --added the below logic as changing customer bill split

Line 144: UPDATE pa_project_customers SET customer_bill_split = 100

140: --sunkalya:federal Bug#5511353
141:
142: IF l_orig_date_eff_funds_flag = 'N' THEN --sunkalya:federal Bug#5511353
143:
144: UPDATE pa_project_customers SET customer_bill_split = 100
145: WHERE customer_id = p_contr_update_cust AND project_id = p_project_id;
146:
147: UPDATE pa_project_customers SET customer_bill_split = 0
148: WHERE customer_id <> p_contr_update_cust AND project_id = p_project_id;

Line 147: UPDATE pa_project_customers SET customer_bill_split = 0

143:
144: UPDATE pa_project_customers SET customer_bill_split = 100
145: WHERE customer_id = p_contr_update_cust AND project_id = p_project_id;
146:
147: UPDATE pa_project_customers SET customer_bill_split = 0
148: WHERE customer_id <> p_contr_update_cust AND project_id = p_project_id;
149:
150: END IF;
151:

Line 156: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'

152: ELSIF p_mode = 'ENABLE' THEN
153: UPDATE pa_tasks SET customer_id = p_def_top_task_cust
154: WHERE project_id = p_project_id;
155:
156: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'
157: WHERE customer_id = p_def_top_task_cust AND project_id = p_project_id;
158:
159: UPDATE pa_project_customers SET customer_bill_split = null
160: WHERE project_id = p_project_id;

Line 159: UPDATE pa_project_customers SET customer_bill_split = null

155:
156: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'
157: WHERE customer_id = p_def_top_task_cust AND project_id = p_project_id;
158:
159: UPDATE pa_project_customers SET customer_bill_split = null
160: WHERE project_id = p_project_id;
161:
162: --Commented out call below for bug 3882790
163: --Project_funding_level_flag is now set in project form itself

Line 334: FROM pa_project_customers proj_cust, ra_customers ra_cust

330:
331: /* Changes for TCA
332: CURSOR cur_get_ordered_customers IS
333: SELECT ra_cust.customer_id , ra_cust.customer_name , ra_cust.customer_number, 'Y'
334: FROM pa_project_customers proj_cust, ra_customers ra_cust
335: WHERE proj_cust.project_id = p_project_id
336: AND proj_cust.customer_id = ra_cust.customer_id
337: ORDER BY proj_cust.customer_bill_split desc, ra_cust.customer_name, ra_cust.customer_number ;
338: */

Line 342: FROM pa_project_customers proj_cust, hz_cust_accounts HZ_C, HZ_PARTIES HZ_P

338: */
339:
340: CURSOR cur_get_ordered_customers IS
341: SELECT HZ_C.cust_account_id , HZ_P.party_name , HZ_P.party_number, 'Y'
342: FROM pa_project_customers proj_cust, hz_cust_accounts HZ_C, HZ_PARTIES HZ_P
343: WHERE proj_cust.project_id = p_project_id
344: AND proj_cust.customer_id = hz_c.cust_account_id
345: AND hz_c.party_id = hz_p.party_id
346: ORDER BY proj_cust.customer_bill_split desc, hz_p.party_name, HZ_P.party_number ;

Line 1115: FROM pa_project_customers ppc, ra_customers rc

1111:
1112: /* Changes for TCA
1113: CURSOR cur_get_top_task_customer IS
1114: SELECT ppc.customer_id, rc.customer_name, rc.customer_number
1115: FROM pa_project_customers ppc, ra_customers rc
1116: WHERE ppc.project_id = p_project_id
1117: AND ppc.default_top_task_cust_flag = 'Y'
1118: AND ppc.customer_id = rc.customer_id ;
1119: */

Line 1123: FROM pa_project_customers ppc, hz_cust_accounts HZ_C, hz_parties HZ_P

1119: */
1120:
1121: CURSOR cur_get_top_task_customer IS
1122: SELECT ppc.customer_id, hz_p.party_name, hz_p.party_number
1123: FROM pa_project_customers ppc, hz_cust_accounts HZ_C, hz_parties HZ_P
1124: WHERE ppc.project_id = p_project_id
1125: AND ppc.default_top_task_cust_flag = 'Y'
1126: AND ppc.customer_id = hz_c.cust_account_id
1127: AND hz_c.party_id = hz_p.party_id;

Line 1244: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'

1240: AND customer_id = p_customer_id ;
1241:
1242: IF x_cust_id IS NOT NULL THEN
1243: x_cust_assoc := 'T';
1244: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'
1245: WHERE project_id = p_project_id
1246: AND customer_id = x_cust_id;
1247: END IF;
1248:

Line 1267: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'

1263: , x_msg_count => x_msg_count
1264: , x_msg_data => x_msg_data );
1265: IF 'S' = x_return_status AND x_cust_id IS NOT NULL THEN
1266: x_cust_assoc := 'D';
1267: UPDATE pa_project_customers SET default_top_task_cust_flag = 'Y'
1268: WHERE project_id = p_project_id
1269: AND customer_id = x_cust_id;
1270: END IF;
1271: END IF;