APPS.PSB_WS_OPS_PVT dependencies on PSB_WS_SUBMIT_SERVICE_PACKAGES

Line 745: FROM psb_ws_submit_service_packages

741: -- If yes, then we need to consider only those account lines which are
742: -- related to the service package selection.
743: --
744: SELECT count(*) INTO l_service_package_count
745: FROM psb_ws_submit_service_packages
746: WHERE worksheet_id = p_worksheet_id
747: AND operation_id = NVL( p_service_package_operation_id ,
748: FND_API.G_MISS_NUM ) ;
749: FOR l_lines_rec IN

Line 762: FROM psb_ws_submit_service_packages

758: AND ( l_service_package_count = 0
759: OR
760: accts.service_package_id IN
761: ( SELECT service_package_id
762: FROM psb_ws_submit_service_packages
763: WHERE worksheet_id = p_worksheet_id
764: AND operation_id = p_service_package_operation_id )
765: )
766: )

Line 859: FROM psb_ws_submit_service_packages sp

855: WHERE accts.position_line_id = pos_lines.position_line_id
856: AND accts.service_package_id IN
857: (
858: SELECT sp.service_package_id
859: FROM psb_ws_submit_service_packages sp
860: WHERE worksheet_id = p_worksheet_id
861: AND operation_id = p_service_package_operation_id
862: )
863: )

Line 4946: FROM psb_ws_submit_service_packages

4942: SELECT COUNT(*) INTO l_service_package_count
4943: FROM dual
4944: WHERE EXISTS
4945: ( SELECT 1
4946: FROM psb_ws_submit_service_packages
4947: WHERE worksheet_id = p_worksheet_id
4948: AND operation_id = p_operation_id ) ;
4949:
4950: IF l_service_package_count = 0 THEN

Line 5010: FROM psb_ws_submit_service_packages

5006: WHERE worksheet_id = p_worksheet_id
5007: )
5008: AND service_package_id IN
5009: ( SELECT service_package_id
5010: FROM psb_ws_submit_service_packages
5011: WHERE worksheet_id = p_worksheet_id
5012: AND operation_id = p_operation_id
5013: ) ;
5014: --

Line 5031: FROM psb_ws_submit_service_packages

5027: WHERE worksheet_id = p_worksheet_id
5028: )
5029: AND service_package_id IN
5030: ( SELECT service_package_id
5031: FROM psb_ws_submit_service_packages
5032: WHERE worksheet_id = p_worksheet_id
5033: AND operation_id = p_operation_id
5034: ) ;
5035:

Line 5050: FROM psb_ws_submit_service_packages

5046: WHERE worksheet_id = p_worksheet_id
5047: )
5048: AND service_package_id IN
5049: ( SELECT service_package_id
5050: FROM psb_ws_submit_service_packages
5051: WHERE worksheet_id = p_worksheet_id
5052: AND operation_id = p_operation_id
5053: ) ;
5054: --

Line 6460: -- Delete from psb_ws_submit_service_packages.

6456: -- Delete from psb_ws_distributions.
6457: DELETE psb_ws_distributions
6458: WHERE worksheet_id = p_worksheet_id ;
6459:
6460: -- Delete from psb_ws_submit_service_packages.
6461: DELETE psb_ws_submit_service_packages
6462: WHERE worksheet_id = p_worksheet_id ;
6463:
6464: -- Delete from psb_ws_user_profiles.

Line 6461: DELETE psb_ws_submit_service_packages

6457: DELETE psb_ws_distributions
6458: WHERE worksheet_id = p_worksheet_id ;
6459:
6460: -- Delete from psb_ws_submit_service_packages.
6461: DELETE psb_ws_submit_service_packages
6462: WHERE worksheet_id = p_worksheet_id ;
6463:
6464: -- Delete from psb_ws_user_profiles.
6465: DELETE psb_ws_user_profiles

Line 6817: FROM psb_ws_submit_service_packages

6813: -- If yes, then we need to consider only those account lines which are
6814: -- related to the service package selection.
6815: --
6816: SELECT count(*) INTO l_service_package_count
6817: FROM psb_ws_submit_service_packages
6818: WHERE worksheet_id = p_worksheet_id
6819: AND operation_id = NVL( p_service_package_operation_id ,
6820: FND_API.G_MISS_NUM ) ;
6821: --

Line 6853: FROM psb_ws_submit_service_packages sp

6849: WHERE accts.position_line_id = pos_lines.position_line_id
6850: AND accts.service_package_id IN
6851: (
6852: SELECT sp.service_package_id
6853: FROM psb_ws_submit_service_packages sp
6854: WHERE worksheet_id = p_worksheet_id
6855: AND operation_id = p_service_package_operation_id
6856: )
6857: )