APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_WS_SUBMIT_SERVICE_PACKAGES

Line 1138: -- even though psb_ws_submit_service_packages will have no records in it.

1134: WHERE worksheet_id = l_worksheet_id ;
1135:
1136: -- Note when a user starts submission process without clickin on service
1137: -- package button, this means all service packages are being selected
1138: -- even though psb_ws_submit_service_packages will have no records in it.
1139: SELECT COUNT(*) INTO l_service_package_count
1140: FROM dual
1141: WHERE EXISTS
1142: ( SELECT 1

Line 1143: FROM psb_ws_submit_service_packages

1139: SELECT COUNT(*) INTO l_service_package_count
1140: FROM dual
1141: WHERE EXISTS
1142: ( SELECT 1
1143: FROM psb_ws_submit_service_packages
1144: WHERE worksheet_id = l_worksheet_id
1145: AND operation_id = l_operation_id ) ;
1146:
1147: -- Get all parent worksheets for the selected worksheet.

Line 1185: FROM psb_ws_submit_service_packages ssp

1181: OR
1182: accts.service_package_id IN
1183: (
1184: SELECT ssp.service_package_id
1185: FROM psb_ws_submit_service_packages ssp
1186: WHERE ssp.worksheet_id = l_worksheet_id
1187: AND ssp.operation_id = l_operation_id
1188: )
1189: )

Line 1212: FROM psb_ws_submit_service_packages

1208: WHERE accts.account_line_id = lines.account_line_id
1209: AND accts.service_package_id NOT IN
1210: (
1211: SELECT service_package_id
1212: FROM psb_ws_submit_service_packages
1213: WHERE worksheet_id = l_worksheet_id
1214: AND operation_id = l_operation_id
1215: )
1216: ) ;

Line 1253: FROM psb_ws_submit_service_packages ssp

1249: OR
1250: accts.service_package_id IN
1251: (
1252: SELECT ssp.service_package_id
1253: FROM psb_ws_submit_service_packages ssp
1254: WHERE ssp.worksheet_id = l_worksheet_id
1255: AND ssp.operation_id = l_operation_id
1256: )
1257: )

Line 1284: FROM psb_ws_submit_service_packages ssp

1280: AND lines.account_line_id = accts.account_line_id
1281: AND accts.service_package_id NOT IN
1282: (
1283: SELECT ssp.service_package_id
1284: FROM psb_ws_submit_service_packages ssp
1285: WHERE ssp.worksheet_id = l_worksheet_id
1286: AND ssp.operation_id = l_operation_id
1287: )
1288: ) ;