DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_CUST_TOTAL_AMTS

Line 1064: FROM oe_cust_total_amts

1060: BEGIN
1061:
1062: SELECT period1_total_amount
1063: INTO x_total_amount
1064: FROM oe_cust_total_amts
1065: WHERE sold_to_org_id = p_cust_id;
1066:
1067: EXCEPTION
1068: WHEN no_data_found THEN

Line 1147: FROM oe_cust_total_amts

1143: BEGIN
1144:
1145: SELECT period2_total_amount
1146: INTO x_total_amount
1147: FROM oe_cust_total_amts
1148: WHERE sold_to_org_id = p_cust_id;
1149:
1150: EXCEPTION
1151: WHEN no_data_found THEN

Line 1229: FROM oe_cust_total_amts

1225: BEGIN
1226:
1227: SELECT period3_total_amount
1228: INTO x_total_amount
1229: FROM oe_cust_total_amts
1230: WHERE sold_to_org_id = p_cust_id;
1231:
1232: EXCEPTION
1233: WHEN no_data_found THEN