APPS.PSB_WS_DISTRIBUTION_RULES_PVT dependencies on PSB_WS_DISTRIBUTIONS

Line 809: FROM psb_ws_distributions

805: IS
806:
807: CURSOR C IS
808: SELECT rowid
809: FROM psb_ws_distributions
810: WHERE distribution_id = p_distribution_id ;
811:
812: --
813: P_LAST_UPDATE_DATE DATE;

Line 860: INSERT INTO psb_ws_distributions

856: raise FND_API.G_EXC_ERROR;
857: end if;
858: --
859:
860: INSERT INTO psb_ws_distributions
861: ( distribution_id,
862: distribution_rule_id,
863: worksheet_id,
864: distribution_date,

Line 1123: FROM psb_ws_distributions

1119: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1120: --
1121:
1122: SELECT count(*) INTO l_ws_count
1123: FROM psb_ws_distributions
1124: WHERE distribution_rule_id = p_distribution_rule_id;
1125:
1126: IF (l_ws_count <> 0) THEN
1127: FND_MESSAGE.SET_NAME('PSB', 'PSB_RULE_IS_DISTRIBUTED');