DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_CUST_TOTAL_AMTS

Line 1072: FROM oe_cust_total_amts

1068: BEGIN
1069:
1070: SELECT period1_total_amount
1071: INTO x_total_amount
1072: FROM oe_cust_total_amts
1073: WHERE sold_to_org_id = p_cust_id;
1074:
1075: EXCEPTION
1076: WHEN no_data_found THEN

Line 1155: FROM oe_cust_total_amts

1151: BEGIN
1152:
1153: SELECT period2_total_amount
1154: INTO x_total_amount
1155: FROM oe_cust_total_amts
1156: WHERE sold_to_org_id = p_cust_id;
1157:
1158: EXCEPTION
1159: WHEN no_data_found THEN

Line 1237: FROM oe_cust_total_amts

1233: BEGIN
1234:
1235: SELECT period3_total_amount
1236: INTO x_total_amount
1237: FROM oe_cust_total_amts
1238: WHERE sold_to_org_id = p_cust_id;
1239:
1240: EXCEPTION
1241: WHEN no_data_found THEN